| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can l automate colours in a graph
Macros have been setup within excel so l can dump data into it and all the
graphs update. There are colors assigned to certain categories however when you dump new data in we can't keep the colour we want with its category. The data is dumped from Access into excel |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can l automate colours in a graph
Hi cbr1000,
Not sure what you want to do, but if you are willing to use VBA you colud look at the 'Conditional Chart Formatting' example at http://www.edferrero.com/charting.aspx Ed Ferrero http://www.edferrero.com Macros have been setup within excel so l can dump data into it and all the graphs update. There are colors assigned to certain categories however when you dump new data in we can't keep the colour we want with its category. The data is dumped from Access into excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reset the default colours in a line graph | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Default Colours in a Bar Graph | Charts and Charting in Excel | |||
| Automate a Graph? | Charts and Charting in Excel | |||
| I would like to know how to automate graph using drop down list | Charts and Charting in Excel | |||
Linear Mode
