Excel graph to show constant target

[DanielGreenwood]

Hi,

I have an excel graph to track performance against a target for several areas of our companies operation.

The x axis is a timeline of months and performace data is input per month. However, the target is set as a fixed value for the whole year and therefore it only appears once in the data source. I can't seem to get this one value to appear for each month in the graph and its driving me crazy!

Is there a way to plot a single value for all instances of the other data plotted?

Your help will be much appreciated.

Thanks

Dan

 

[xlhelp]

Why can you not put target in another column and plot it as well; as another series? You could always hide the columns if don't want to see it.

Member- AAAA Association Against Acronym Abusers

 

[Hasit]

The simplest way I tend to use is to plot a value equivalent to the target.

Then plot using a "Line - Column" chart.