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
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
