Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
bar graphs | Charts and Charting in Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
GRAPHS PLEASE HEL | Excel Discussion (Misc queries) | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |