Excel Chart displaying 2 different data

[FreshBe]

Sorry about the title but not sure how to describe the issue.

I have a standard line chart with 2 series of data in it - not a problem so far.

What I can't seem to do is take data from another column in a sheet and add lines across the chat at the values from the column and where they are on the Y axis.

What I am trying to achieve is a line chart with 2 series and a band of lines across the chart giving me an upper and lower limit.

 

[SkipVought]

Hi,

Your UPPER and LOWER limits can be each an additional series.

Copy the new ranges

Select the chart

Edit/Paste Special -- add series.

VOLA!

Skip,
[sub]
[red][/red]
[/sub]

 

[FreshBe]

Thanks for the response, I have tried this but I just end up with another series as a line chart, what I am after is the series just to be straight lines from left to right all the way across the chart at the value on the y axis of the data from a cell, if you have an email address I can mail you a n example that I have done in paint to demo what I need it to look like.

 

[GlennUK]

You are not generating series of single values by the sound of it. Have a series a numbers all the same to be your upper limit, and another series to be your lower limit.

By the way, asking to take your problem off-line via email goes against the whole point of having a forum, as is considered back practise.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[MeGustaXL]

I like to do this with Single-Point dummy series and Error Bars.

[b]Series  X value       Y Value[/b]
Upper      0      Whatever your UL is
Lower      0      Whatever your LL is

Paste these in the chart as new series

Click the markers on the Y-Axis and set the X-Error Bars to Custom type Plus, with a value equal to your highest X-value.

Format the Error Bars as Red and Green, dashed, No Markers, Fairly thick-ish (or any way that you like)

BINGO!

Chris

Beer is God's way of telling us He loves us and wants us to be happy - Benjamin Franklin

 

[MeGustaXL]

Ooops! I just re-read your post and see that you're using a Line Chart; my suggestion won't work 'cos Line Charts don't have X Error Bars Sorry!

Unless I can persuade you to use an X-Y Chart, you'll probably have to do it Skip's way.

This article in Quality Digest shows how to do Shewhart Charts and Control Charts -
Using Excel for Data Analysis

http://www.qualitydigest.com/oct97/html/excel.html

Chris

Beer is God's way of telling us He loves us and wants us to be happy - Benjamin Franklin

 

[MeGustaXL]

This is good as well:

http://gunston.gmu.edu/708/UsingExcelToPlot.ppt

Chris

Beer is God's way of telling us He loves us and wants us to be happy - Benjamin Franklin

 

[FreshBe]

Thanks all for your suggestions, The upper and lower limit is nearly what I need but I need to have lines going accross the chart for each value that I specify not just for the upper and lower limit.

GlennUK (MIS) - sorry, I was not trying to take the thread offline just email a picture of an example to what I want it to look like as I don't seem to ba able to post and image on here.

 

[MeGustaXL]

A bit like this?

|[red]----------------------------------[/red]X
|
|
|-----------------------X
|-----------------X
|
|
|----------X
|____________________________________

If that's the kind of thing you're after, make it an X-Y Chart and use Minus X Error Bars

BINGO!

Chris

Beer is God's way of telling us He loves us and wants us to be happy - Benjamin Franklin

 

[FreshBe]

Top Man MeGustaXL's exactly what I'm after, thanks for that



Darren