Plotting Targets on a column graph
 

I have a measure and a target for that measure. I would like to plot them on
the same column in a graph rather than as another series. I would like the
solid column to have a dotted rectangle on the top to show how far the
measure is short of the target.

Plotting Targets on a column graph
 

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"LJDL" wrote in message
...
I have a measure and a target for that measure. I would like to plot them
on
the same column in a graph rather than as another series. I would like the
solid column to have a dotted rectangle on the top to show how far the
measure is short of the target.