General discussion

Locked

Graphs in Excel

By keepbelieving ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Graphs in Excel

by DKlippert In reply to Graphs in Excel

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.

Collapse -

Graphs in Excel

by keepbelieving In reply to Graphs in Excel

Thanks this helped a lot...why didn't I think of that?

Collapse -

Graphs in Excel

by keepbelieving In reply to Graphs in Excel

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums