A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Charting data points and show a target range on the same chart.



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2005, 08:55 PM
Minireefkeeper
external usenet poster
 
Posts: n/a
Default Charting data points and show a target range on the same chart.

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #2  
Old April 16th, 2005, 02:50 AM
Barb R.
external usenet poster
 
Posts: n/a
Default

If it were me, I'd plot this using a control chart. Take a look at Jon
Peltier's example he

http://www.peltiertech.com/Excel/Cha...nChtLines.html

"Minireefkeeper" wrote:

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #3  
Old April 16th, 2005, 06:50 PM
John Mansfield
external usenet poster
 
Posts: n/a
Default

There are several ways to do this. The example illustrates an approach that
uses a combined line - stacked column chart:

To add the highlighted range and assuming you acceptable range is 8.1 - 8.5,
set your data up like below. The first column is the date or time of your ph
reading. The second column is you ph reading. The third and fourth columns
will be used to set up highlighted range. The third column is the bottom of
the range you want to highlight. The fourth column is the top of the range
you want to highlight.

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Assuming the data set above spans the range A16, create a Stacked Column
chart based on the entire data set.

Next, click once on the series in the stacked column chart that contains
your actual data (it's the bottom column within each stacked column).
Right-click on your mouse and select Chart Type - Line -OK.

Click once on the bottom set of columns. Right-click on your mouse and
select Selected Object. In the Format Data Series dialog box, go to the
Patterns tab. Set the Border = None and the Area = None.

Click once on the middle set of columns (they should be the only columns
appearing in the chart now. Right-click on your mouse and select Selected
Object. In the Format Data Series dialog box, go to the Patterns tab. Set
the Border = None. Finally, still within the Format Data Series dialog box,
go to the options tab and set the gap width to zero.

----
Regards,
John Mansfield
http://www.pdbook.com

"Minireefkeeper" wrote:

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #4  
Old April 16th, 2005, 07:23 PM
John Mansfield
external usenet poster
 
Posts: n/a
Default

A second, and easier method is to use a stacked area chart. Assuming the
same data set,

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Select the range. Go to the Chart Wizard and, under the standard types,
select - Area - Stacked Area. Go though the rest of the Chart Wizard
prompts until your appears on you page.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Chart Type - Line - OK.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Selected Object. In the Format Data Series - Patterns Tab,
set the border = None and the Patterns = None.

----
Regards,
John Mansfield
http://www.pdbook.com



"John Mansfield" wrote:

There are several ways to do this. The example illustrates an approach that
uses a combined line - stacked column chart:

To add the highlighted range and assuming you acceptable range is 8.1 - 8.5,
set your data up like below. The first column is the date or time of your ph
reading. The second column is you ph reading. The third and fourth columns
will be used to set up highlighted range. The third column is the bottom of
the range you want to highlight. The fourth column is the top of the range
you want to highlight.

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Assuming the data set above spans the range A16, create a Stacked Column
chart based on the entire data set.

Next, click once on the series in the stacked column chart that contains
your actual data (it's the bottom column within each stacked column).
Right-click on your mouse and select Chart Type - Line -OK.

Click once on the bottom set of columns. Right-click on your mouse and
select Selected Object. In the Format Data Series dialog box, go to the
Patterns tab. Set the Border = None and the Area = None.

Click once on the middle set of columns (they should be the only columns
appearing in the chart now. Right-click on your mouse and select Selected
Object. In the Format Data Series dialog box, go to the Patterns tab. Set
the Border = None. Finally, still within the Format Data Series dialog box,
go to the options tab and set the gap width to zero.

----
Regards,
John Mansfield
http://www.pdbook.com

"Minireefkeeper" wrote:

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #5  
Old April 17th, 2005, 01:12 AM
MiniReefKeeper
external usenet poster
 
Posts: n/a
Default

That was EXCEPTIONALLY helpful! Thank you. I have numerous applications I
can apply this too. Thanks so much,
MiniReefKeeper

"John Mansfield" wrote:

A second, and easier method is to use a stacked area chart. Assuming the
same data set,

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Select the range. Go to the Chart Wizard and, under the standard types,
select - Area - Stacked Area. Go though the rest of the Chart Wizard
prompts until your appears on you page.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Chart Type - Line - OK.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Selected Object. In the Format Data Series - Patterns Tab,
set the border = None and the Patterns = None.

----
Regards,
John Mansfield
http://www.pdbook.com



"John Mansfield" wrote:

There are several ways to do this. The example illustrates an approach that
uses a combined line - stacked column chart:

To add the highlighted range and assuming you acceptable range is 8.1 - 8.5,
set your data up like below. The first column is the date or time of your ph
reading. The second column is you ph reading. The third and fourth columns
will be used to set up highlighted range. The third column is the bottom of
the range you want to highlight. The fourth column is the top of the range
you want to highlight.

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Assuming the data set above spans the range A16, create a Stacked Column
chart based on the entire data set.

Next, click once on the series in the stacked column chart that contains
your actual data (it's the bottom column within each stacked column).
Right-click on your mouse and select Chart Type - Line -OK.

Click once on the bottom set of columns. Right-click on your mouse and
select Selected Object. In the Format Data Series dialog box, go to the
Patterns tab. Set the Border = None and the Area = None.

Click once on the middle set of columns (they should be the only columns
appearing in the chart now. Right-click on your mouse and select Selected
Object. In the Format Data Series dialog box, go to the Patterns tab. Set
the Border = None. Finally, still within the Format Data Series dialog box,
go to the options tab and set the gap width to zero.

----
Regards,
John Mansfield
http://www.pdbook.com

"Minireefkeeper" wrote:

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #6  
Old April 17th, 2005, 04:36 PM
John Mansfield
external usenet poster
 
Posts: n/a
Default

You're welcome. Additionally, I've added an explanation to my site for
documentation.

http://www.pdbook.com/index.php/exce...ed_area_chart/

----
Regards,
John Mansfield
http://www.pdbook.com

"MiniReefKeeper" wrote:

That was EXCEPTIONALLY helpful! Thank you. I have numerous applications I
can apply this too. Thanks so much,
MiniReefKeeper

"John Mansfield" wrote:

A second, and easier method is to use a stacked area chart. Assuming the
same data set,

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Select the range. Go to the Chart Wizard and, under the standard types,
select - Area - Stacked Area. Go though the rest of the Chart Wizard
prompts until your appears on you page.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Chart Type - Line - OK.

Click once on the series at the bottom of the chart. Right-click on you
mouse. Select Selected Object. In the Format Data Series - Patterns Tab,
set the border = None and the Patterns = None.

----
Regards,
John Mansfield
http://www.pdbook.com



"John Mansfield" wrote:

There are several ways to do this. The example illustrates an approach that
uses a combined line - stacked column chart:

To add the highlighted range and assuming you acceptable range is 8.1 - 8.5,
set your data up like below. The first column is the date or time of your ph
reading. The second column is you ph reading. The third and fourth columns
will be used to set up highlighted range. The third column is the bottom of
the range you want to highlight. The fourth column is the top of the range
you want to highlight.

4/16/2004 8.3 8.1 0.4
4/17/2004 8.6 8.1 0.4
4/18/2004 8.4 8.1 0.4
4/19/2004 8.2 8.1 0.4
4/20/2004 8.4 8.1 0.4
4/21/2004 8.6 8.1 0.4

Assuming the data set above spans the range A16, create a Stacked Column
chart based on the entire data set.

Next, click once on the series in the stacked column chart that contains
your actual data (it's the bottom column within each stacked column).
Right-click on your mouse and select Chart Type - Line -OK.

Click once on the bottom set of columns. Right-click on your mouse and
select Selected Object. In the Format Data Series dialog box, go to the
Patterns tab. Set the Border = None and the Area = None.

Click once on the middle set of columns (they should be the only columns
appearing in the chart now. Right-click on your mouse and select Selected
Object. In the Format Data Series dialog box, go to the Patterns tab. Set
the Border = None. Finally, still within the Format Data Series dialog box,
go to the options tab and set the gap width to zero.

----
Regards,
John Mansfield
http://www.pdbook.com

"Minireefkeeper" wrote:

Can anyone offer advise on how to make a chart of data points (line) with in
a particular range of target values? Speciffically, I am try to chart the pH
values of my fish tank. I know how to plot the data points on a line graph,
but I'd like to add a visual "highlighted" target range section. Ie, my data
records the pH for three days (8.2, 8.4, 8.5). pH on the y-axis and the date
on the x-axis. The acceptable range for the pH values for a sal****er tank
is 8.1 - 8.5 How can I indicate this target range within the chart? Once I
learn how to do this I can apply it to other tests (nitrates etc..)
i'd sure appreciate some help...

  #7  
Old February 18th, 2006, 07:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Charting data points and show a target range on the same chart


Wit U Talkin Aboot Ya BigFat Wamk


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get 3 series in sync with the x-axis? zizbird Charts and Charting 10 October 25th, 2004 01:23 PM
X, Plus, and Star marker styles do not show all data points L Mehl Charts and Charting 2 June 8th, 2004 05:03 AM
Not showing Data points with Zero value Neal Charts and Charting 3 December 7th, 2003 05:11 AM


All times are GMT +1. The time now is 10:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.