Add target to trend chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a chart trending our company's daily rank over time. We have a
specific rank as a target goal, and I'd like that to appear as a flat line on
the chart, so we know how far we have to go. How can I get such a line,
without having to populate a new column with the same number?

Thanks
 
Two options,

1) Simply draw a line where your target is at using the drawing toolbar.
2) Add an additional series to your chart containing two points. The X
value of the points indicates the length of your line. The Y values should
be set to your target.
 

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

Microsoft office2010 trend lines 1
Pivot Chart Trendline? 0
Pivot Table Charts 1
PowerPoint Embed scroll excel chart and data in powerpoint 0
Charts-Target Lines 1
Is there a way to recalculate trend lines in Excel charts? 1
Chart bar colours 3
League position change trend chart, how? 1

Back
Top