Chart Help

[Shaun]

Hi,

I would like to create a chart with three items: date, time, and
average hr. The problem I am having is getting the time and av hr on
the same graph because of the large difference in numbers (time is
around 15min and av hr is about 160. How can I get the date on the x
axis and on the right/left y axis the time and on the other right/left
y axis av hr? Thank you very much in advance.

Shaun

 

[Mike Middleton]

Shaun -

The usual approach is to create a chart with two data series and then format
one data series to use a secondary axis.

For a Line chart type, you would have a data series for time and a data
series for av hr (with date as horizontal axis labels).

For an XY (Scatter) chart type, you would have one X/Y data series for
date/time and another X/Y data series for date/av hr.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Carl Witthoft]

He's right, but creating a compound chart isn't easy. So long as both
sets of data use the same x-values (dates) you can create an XY scatter
chart as he said, and at some point select one of the series (click on
the points or line) , select "format selected series," and somewhere in
the dialog box click on the Secondary Axis box.

When it comes to a chart w/ two different types of display, it gets
messier. I once overlaid a bar-chart histogram with the controlling
"bell curve" distribution function, but it took some hacking

Carl

 

[Mike Middleton]

Carl Witthoft -

A combination chart is not needed, and it is not what I described.

Either you create an XY (Scatter) chart with two data series, or you create
a Line chart with two data series. Then you select one series, and use the
Format menu to use a secondary axis for the selected series.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Carl Witthoft]

Sorry if I led anyone astray. I fully agree that the OP just needs a
two-axis scatterchart. The rest of my comment was an unrelated
anecdote.

 

[Shaun]

Sorry if I led anyone astray. I fully agree that the OP just needs a
two-axis scatterchart. The rest of my comment was an unrelated
anecdote.

Carl Witthoft -

A combination chart is not needed, and it is not what I described.

Either you create an XY (Scatter) chart with two data series, or you create
a Line chart with two data series. Then you select one series, and use the
Format menu to use a secondary axis for the selected series.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

He's right, but creating a compound chart isn't easy. So long as both
sets of data use the same x-values (dates) you can create an XY scatter
chart as he said, and at some point select one of the series (click on
the points or line) , select "format selected series," and somewhere in
the dialog box click on the Secondary Axis box.
When it comes to a chart w/ two different types of display, it gets
messier. I once overlaid a bar-chart histogram with the controlling
"bell curve" distribution function, but it took some hacking
Carl

Thank you for the input and I will try it out.