graphs


E

excelguy

I made a graph in Excel 2003. The x axis is the grades of a final exam 0-100.
The y axis is final grades 0 - 100. Is there a way to make a colored line
appear on the y axis to mark a certain grade? I want a red line to appear on
the y axis to show grades above and below 65.

I couldn't find how to do this in the chart options on 2003.
thanks
 
Ad

Advertisements

L

Luke M

Simply create a dummy series and add it to your graph.

In a 2x2 cell area:

0........65
100.....65

Copy these cells, Select chart, paste special, add as new series. If needed,
you can select this series, and go to Chart - Type to change it to a line,
and then format as desired.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning values to a variable set 1
Excel chart does not start at zero. 1
Scale of Graph Axis 2
Exel - add vertical line to two axis graph 0
Graphs 1
Chart in Access 3
graphing troubles 2
Basic Graph help 2

Top