| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
color of last bar on bar chart
I have a dynamic rolling 13 month bar chart, but want to color the current
month (right-most bar) a different color to the other bars. Can this be done? (needs to work as chart rolls forward each month). Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
color of last bar on bar chart
Hi,
Simplest thing to do, without introducing VBA, is to use another dummy series which only has data for the last point. You can set the Series Option for Overlap to 100. This will place the columns/bars on top of one another so the new series will obscure the main data series. Cheers Andy PBcorn wrote: I have a dynamic rolling 13 month bar chart, but want to color the current month (right-most bar) a different color to the other bars. Can this be done? (needs to work as chart rolls forward each month). Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
color of last bar on bar chart
If by 'dynamic' you mean a dynamic range defines the series, unless I'm
missing something why not simply format the last point to a different colour. Regards, Peter T "PBcorn" wrote in message ... I have a dynamic rolling 13 month bar chart, but want to color the current month (right-most bar) a different color to the other bars. Can this be done? (needs to work as chart rolls forward each month). Thanks |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
color of last bar on bar chart
Yes this does what I need. For some reason I thought it might be a more
difficult problem! thanks "Peter T" wrote: If by 'dynamic' you mean a dynamic range defines the series, unless I'm missing something why not simply format the last point to a different colour. Regards, Peter T "PBcorn" wrote in message ... I have a dynamic rolling 13 month bar chart, but want to color the current month (right-most bar) a different color to the other bars. Can this be done? (needs to work as chart rolls forward each month). Thanks |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
color of last bar on bar chart
It would have been more difficult if your chart was not rolling.
Peter picked up on that point and suggested the more obvious solution :) Cheers Andy PBcorn wrote: Yes this does what I need. For some reason I thought it might be a more difficult problem! thanks "Peter T" wrote: If by 'dynamic' you mean a dynamic range defines the series, unless I'm missing something why not simply format the last point to a different colour. Regards, Peter T "PBcorn" wrote in message ... I have a dynamic rolling 13 month bar chart, but want to color the current month (right-most bar) a different color to the other bars. Can this be done? (needs to work as chart rolls forward each month). Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart color | Charts and Charting in Excel | |||
| Chart Color | Excel Discussion (Misc queries) | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| 2 color bar chart? | Charts and Charting in Excel | |||
| How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
Linear Mode
