Chart Help

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

In article <uulGOQ4MIHA.5140.DeleteThis@TK2MSFTNGP05.phx.gbl>,
"Mike Middleton" <mike.DeleteThis@mikemiddleton.com> wrote:

> 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
>
>
>
> "Shaun" <sriebl.DeleteThis@gmail.com> wrote in message
> news:746619e9-cd7b-48ae-b69f-b9c5c9a29139@f3g2000hsg.googlegroups.com...
> > 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

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: Chart Help 

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" <carl.TakeThisOut@witthoft.com> wrote in message
news:carl-B0B155.16405230112007@comcast.dca.giganews.com...
> 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
>
> In article <uulGOQ4MIHA.5140.TakeThisOut@TK2MSFTNGP05.phx.gbl>,
> "Mike Middleton" <mike.TakeThisOut@mikemiddleton.com> wrote:
>
>> 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
>>
>>
>>
>> "Shaun" <sriebl.TakeThisOut@gmail.com> wrote in message
>> news:746619e9-cd7b-48ae-b69f-b9c5c9a29139@f3g2000hsg.googlegroups.com...
>> > 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
>
> --
> Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: Chart Help 

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.


In article <utpC1f6MIHA.6060.TakeThisOut@TK2MSFTNGP05.phx.gbl>,
"Mike Middleton" <mike.TakeThisOut@mikemiddleton.com> wrote:

> 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" <carl.TakeThisOut@witthoft.com> wrote in message
> news:carl-B0B155.16405230112007@comcast.dca.giganews.com...
> > 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
> >
> > In article <uulGOQ4MIHA.5140.TakeThisOut@TK2MSFTNGP05.phx.gbl>,
> > "Mike Middleton" <mike.TakeThisOut@mikemiddleton.com> wrote:
> >
> >> 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
> >>
> >>
> >>
> >> "Shaun" <sriebl.TakeThisOut@gmail.com> wrote in message
> >> news:746619e9-cd7b-48ae-b69f-b9c5c9a29139@f3g2000hsg.googlegroups.com...
> >> > 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
> >
> > --
> > Team EM to the rescue! http://www.team-em.com

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: Chart Help 

On Dec 2, 11:29 am, Carl Witthoft <c....RemoveThis@witthoft.com> wrote:
> 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.
>
> In article <utpC1f6MIHA.6....RemoveThis@TK2MSFTNGP05.phx.gbl>,
> "Mike Middleton" <m....RemoveThis@mikemiddleton.com> wrote:
>
>
>
> > 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" <c....RemoveThis@witthoft.com> wrote in message
> >news:carl-B0B155.16405230112007@comcast.dca.giganews.com...
> > > 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
>
> > > In article <uulGOQ4MIHA.5....RemoveThis@TK2MSFTNGP05.phx.gbl>,
> > > "Mike Middleton" <m....RemoveThis@mikemiddleton.com> wrote:
>
> > >> 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
>
> > >> "Shaun" <sri....RemoveThis@gmail.com> wrote in message
> > >>news:746619e9-cd7b-48ae-b69f-b9c5c9a29139@f3g2000hsg.googlegroups.com...
> > >> > 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
>
> > > --
> > > Team EM to the rescue! http://www.team-em.com
>
> --
> Team EM to the rescue! http://www.team-em.com

Thank you for the input and I will try it out.
 >> Stay informed about: Chart Help