Chart Colours driving me insane

Grover

New Member
Joined
Apr 23, 2019
Messages
13
Hi
I have set up some charts (40) from a large table of data
Each chart shows 7 different values on a combo chart off 2 vertical axis.Misture of clustered column and line with markers
I have set up 2 drop down boxes that allow me to select the date and number of days back from selected date to allow me to view specific time periods. I.E select 31st May and on other drop down the number 5 and it shows the data from 31st back 5 days, rather than having to go in and select and deselect chart data.
The problem I have is the default chart colours dont work for me with the colour scheme
When i go in and change fill etc its fine, until i change selected data then it defaults back to the original colour. Even trying to customise the colour scheme doesnt help
So i can show a whole month of data but as soon as i select a different number of days it defaults back. Plus when i copy the chart and select different data it doesnt retain any formatting
Any suggestions please
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top