Creating a goal or target line

L

Lintless

I am using a line graph to show my weekly percentages for the year. I have a
goal of keeping these percentages below a specific value. I would like to
have a line across my graph at that specific goal value so I can see which
weeks have exceeded my goal percentage or have remained below it. Is there an
easy way to do this? Also, if possible, I would like my data line to change
color as it crosses that goal line. For example, the line would be black
below that specific goal value, but when the line crosses that goal value it
would turn red. Any suggestions?
 

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

How do I set a goal line in a bar graph? 3
Bar Graph with goal line 1
Goal line or target line to Excell 2007 Chart 5
How do I add a horizonal target/goal line to a line chart? 2
Floating Year-To-Date Line 3
Add a goal line to a column chart 1
how do I add a goal line for a bar chart? 1
Color change on bars when goal met 2

Top