Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello all!
I'm using Excel 2003, and have a charting question: I'm charting some ratios for my work on a line chart, but would better like to show whether the said ratio is "above" or "below" our target by somehow accentuating the "target" on the Y axis. I don't want to create a series called "target" and plot it on the chart. For example, one of my charts has major Y axis numbers of .05, 1, 1.5 and 2. Our "Target" for this particular chart is 1. How can I accentuate this particular axis line on the chart to immediately see at a glance if a particular point is above target or below target?? Much thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
shift Y axis | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel |