Bar charts

[Don Niall]

Hi all,

I have a conventional bar-chart. Is there anyway to make a
SINGLE vertical grid-line a different color? I am trying
to illustrate that anything inside this area is considered
in the danger (red) zone and anything outside of this area
is in the acceptable (green) zone ....?
I cannot select a single gridline for some reason.
Regards,

Don-

 

[Andy Pope]

Hi Don,

You can not format a single gridline.
You can use an additional data series to draw the required line.

Take a look at Jon or my example.
http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

 

[Don Niall]

Thanks Andy,

One issue. In the graph I am using the Data table. Is
there a way of omitting the new series/data points from
this data table? Or is the only way around this to exclude
the entire data table?

Thanks,

Don-

 

[Andy Pope]

Ah! If you want the line using the extra data series method you will
have to lose the data table.

Cheers
Andy