Hopefully simple Excel graph question
Hopefully simple Excel graph question
Author
Discussion

onedsla

Original Poster:

1,115 posts

276 months

Friday 5th February 2010
quotequote all
Hi - hoping somebody can help. Sure there's a simple answer, but struggling to find the right words to google what I'm after.

I have a pretty simple graph, much like this:


I'd like to add a thicker / stand out line at 80 on the x axis.

Can somebody please tell me if / where I may find such an option?
Thanks!

Ultuous

2,275 posts

211 months

Friday 5th February 2010
quotequote all
The way I've approached the same problem in the past is either to draw one on top using the drawing tools (quick but a little messy!) or (the more long-winded but effective way)...

Add another data series to the chart, set the value to 80 for each point in the series, then change the graph type for that series only to line graph, then format the line as required! smile

onedsla

Original Poster:

1,115 posts

276 months

Friday 5th February 2010
quotequote all
Perfect - thanks for your help. Haven't looked at the 'custom graph' types since my school years!

Now back to working on the service behind the data!!!