ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   graphs (https://www.excelbanter.com/excel-discussion-misc-queries/250579-graphs.html)

excelguy[_2_]

graphs
 
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

Luke M

graphs
 
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"excelguy" wrote:

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



All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com