Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary Colors in the Same Data Series
What do I need to do so to enable the box to click to Vary Colors by Point?
Currently this option and the one above it (Series Lines) are "greyed out" for my chart. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary Colors in the Same Data Series
What type of chart. What version of XL? How many data point in a series?
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... What do I need to do so to enable the box to click to Vary Colors by Point? Currently this option and the one above it (Series Lines) are "greyed out" for my chart. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary Colors in the Same Data Series
Clustered bar graph. Excel 2003. There are 9 data points in the series, six
of them have non-zero values. Many thanks! "Bernard Liengme" wrote: What type of chart. What version of XL? How many data point in a series? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... What do I need to do so to enable the box to click to Vary Colors by Point? Currently this option and the one above it (Series Lines) are "greyed out" for my chart. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary Colors in the Same Data Series
Charts with more than one data series cannot use that feature. I expect the
concern is that two points from different series might get same colour and confuse viewer. You can still re-colour each point one-by-one. Click on point twice (not a double click but click-pause-click, to get one point selected - watch for markers around the 'block' making the chart point) Then use Format on menu (or right click to open Format Select Data Point) now you can select a colour. Best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... Clustered bar graph. Excel 2003. There are 9 data points in the series, six of them have non-zero values. Many thanks! "Bernard Liengme" wrote: What type of chart. What version of XL? How many data point in a series? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... What do I need to do so to enable the box to click to Vary Colors by Point? Currently this option and the one above it (Series Lines) are "greyed out" for my chart. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary Colors in the Same Data Series
Much obliged!!
"Bernard Liengme" wrote: Charts with more than one data series cannot use that feature. I expect the concern is that two points from different series might get same colour and confuse viewer. You can still re-colour each point one-by-one. Click on point twice (not a double click but click-pause-click, to get one point selected - watch for markers around the 'block' making the chart point) Then use Format on menu (or right click to open Format Select Data Point) now you can select a colour. Best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... Clustered bar graph. Excel 2003. There are 9 data points in the series, six of them have non-zero values. Many thanks! "Bernard Liengme" wrote: What type of chart. What version of XL? How many data point in a series? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Joseph Reilly" wrote in message ... What do I need to do so to enable the box to click to Vary Colors by Point? Currently this option and the one above it (Series Lines) are "greyed out" for my chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I customize Series colors? | Charts and Charting in Excel | |||
vary row colors in excel? | Excel Discussion (Misc queries) | |||
changing series value colors | Charts and Charting in Excel | |||
Vary bar colors by bar | Charts and Charting in Excel | |||
Vary colors in area chart by x-axis value | Charts and Charting in Excel |