excel line chart

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Line chart with reference values

Excel - Line chart with reference values

resolvedResolved · Low Priority · Version Vista

Fanny has attended:
No courses

Excel - Line chart with reference values

I am ploting a serie of data points using a line chart. I want these data point compared to a fixed minimum value, maximum value and target value. The only way I have found to draw the min, max and target lines on my graph is to have a column for each with the same amount of data as my data points in my source table. It is a bit annoying and I'd rather have an option in my graph where I set a min, max and target value and they appear as traced lines on the graph. The data points of my original serie may be out of these limits so I don't want to change my graph axis parameters. I have a graph example that I can send if needed.

RE: Excel - Line chart with reference values

Hi Fanny,

Thank you for your question and welcome to the forum.

Could you please send me your graph example to:

sk@stl-training.co.uk

Regards

Simon

RE: Excel - Line chart with reference values

Hi Fanny,

Thank you for your response and the attached spreadsheet.

I will have a look at at the data after training today and if I have any suggestions I will email you a response tomorrow.

Regards

Simon


 

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

View all Excel hints and tips


Server loaded in 0.08 secs.