Displaying a horizontal quota line on a graph

  • Thread starter Looking for help today
  • Start date
L

Looking for help today

I have a bar graph showing the data that I want to see. Current data runs
between say 389 and 1902. The quota for this data say is 1000. How can I
insert say a bold horizontal line at the 1000 mark on the axis to better show
the results to these people as to where they are at versus say what I would
call my target line of say 1000. I appreciate any help.
 
A

Alojz

Add another data series to ur chart. Assuming ur data series are in column B,
fill in the C column with value of 1000 in corresponding rows. Expand the
area of data to be visible in chart to those in C column. Then change the
type of chart for this C column data: Right click on C data series in ur
chart and change the chart type to line.

HTH
 
L

Looking for help today

Thank you very much. That did the trick.

Alojz said:
Add another data series to ur chart. Assuming ur data series are in column B,
fill in the C column with value of 1000 in corresponding rows. Expand the
area of data to be visible in chart to those in C column. Then change the
type of chart for this C column data: Right click on C data series in ur
chart and change the chart type to line.

HTH
Click to expand...
 

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

Getting the graph style I want 4
Graph to display Range Label and Mean 0
Line graphs where data comes from formulas. 6
Can't rotate text in graph 0
Grid Line Extensions ? (Excel 2007) 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
Vertical Highlighting on line graph??? 1
Vertical highlighting in line graphs???? 0

Top