Software

Ask something
Discussion Locked

Graphs in Excel

0 helpful
3 replies

by keepbelieving

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi :-)
Please help me! I would like to add a target point to a graph, but can't figure out how to do it. I am using a bar graph that has a targeted budget at 10.5. I would like to place a red line across the chart at that point to show how underor over budget I am. How do I add the line?

3 replies

by dklippert

Column charts are easy. Add an extra data series called Budget with all values of 10.5. Use the custom graph type of Line column.
With a Bar chart, you might cheat and use a line drawn using the Drawing tool bar.

This discussion is closed to new replies.