| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar graph colour changes
I have an excel pareto bar graph. The values are linked to another workbook &
will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar graph colour changes
Hi,
Have a look at Jon's page(s) on conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html VBA maybe another approach you could use. Cheers Andy Baldyman wrote: I have an excel pareto bar graph. The values are linked to another workbook & will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar graph colour changes
Thanks for the idea, I may have to try VBA as the data that will control each
colour won't be appearing as part of the graph. "Andy Pope" wrote: Hi, Have a look at Jon's page(s) on conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html VBA maybe another approach you could use. Cheers Andy Baldyman wrote: I have an excel pareto bar graph. The values are linked to another workbook & will change daily. I want different values to be different colours by selected group, i.e. top value may be yellow, next 2 values red, but next day the top value (yellow) may now be 2nd value but needs to stay yellow. This can be done manually each day, but I wonder can it be done automatically by adding another value to the source data. 1=yellow, 2=red etc. Any help will be gratefully appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change lots of series on a scatter graph to one colour | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| how do i change the colour of individual axis on the graph | Excel Discussion (Misc queries) | |||
| Colour part of a line on an X Y graph | Charts and Charting in Excel | |||
Linear Mode
