Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am trying to change each individual bars color in a 3d bar chart in Excel
2003 based on the data points in the series. Can this even be done in Excel 2003? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Yes by using additional series based on a formula. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Shaun Barton wrote: I am trying to change each individual bars color in a 3d bar chart in Excel 2003 based on the data points in the series. Can this even be done in Excel 2003? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hey Andy,
Thank you for your reply that way looks much easier than the way I solved the problem using VBA code, but much appreciated for the response. Thanks , Shaun Barton "Andy Pope" wrote: Hi, Yes by using additional series based on a formula. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Shaun Barton wrote: I am trying to change each individual bars color in a 3d bar chart in Excel 2003 based on the data points in the series. Can this even be done in Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change point size of all points in an xy chart | Charts and Charting in Excel | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
regarding allocation of chart series point colors | Charts and Charting in Excel | |||
create chart /table excel-save, close & reopen colors change? Why | Charts and Charting in Excel | |||
How do I change one point in a scatter chart color | Charts and Charting in Excel |