I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis
due to different concentrations between the 2 data series. Everytime I try to
add the 2nd axis, I can only view one of the data series.
I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis
due to different concentrations between the 2 data series. Everytime I try to
add the 2nd axis, I can only view one of the data series.
If you are using a secondary axis, check the scaling on both axes. You may
have it set so that you can't see one of the series.
"Laura" <[email protected]> wrote in message
news:[email protected]...
> I am creating a graph in Excel 2002. I have 2 data series and I need 2
y-axis
> due to different concentrations between the 2 data series. Everytime I try
to
> add the 2nd axis, I can only view one of the data series.
Barb,
It seems that when I envoke the 2nd axis, it superimposes the one data
series on top of the other. Ideally, I would like the scales to be the same
on both axis, I just need to show that the units of measurment for the 2 data
series were different. I suggested to our client to just add a footnote, but
they definitely want 2 axis. Any thought?
"Barb Reinhardt" wrote:
> If you are using a secondary axis, check the scaling on both axes. You may
> have it set so that you can't see one of the series.
>
> "Laura" <[email protected]> wrote in message
> news:[email protected]...
> > I am creating a graph in Excel 2002. I have 2 data series and I need 2
> y-axis
> > due to different concentrations between the 2 data series. Everytime I try
> to
> > add the 2nd axis, I can only view one of the data series.
>
>
>
Can you give an example of your data sets and the Primary and Secondary Y
axis ranges? Alternatively, something like this might work for you:
http://peltiertech.com/Excel/Charts/axes.html#StakCht
but I'd work on the secondary axis first before embarking on Stacked charts.
"Laura" <[email protected]> wrote in message
news:[email protected]...
> Barb,
>
> It seems that when I envoke the 2nd axis, it superimposes the one data
> series on top of the other. Ideally, I would like the scales to be the
same
> on both axis, I just need to show that the units of measurment for the 2
data
> series were different. I suggested to our client to just add a footnote,
but
> they definitely want 2 axis. Any thought?
>
> "Barb Reinhardt" wrote:
>
> > If you are using a secondary axis, check the scaling on both axes. You
may
> > have it set so that you can't see one of the series.
> >
> > "Laura" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am creating a graph in Excel 2002. I have 2 data series and I need 2
> > y-axis
> > > due to different concentrations between the 2 data series. Everytime I
try
> > to
> > > add the 2nd axis, I can only view one of the data series.
> >
> >
> >
Laura -
If the scales are the same on both axes, isn't the second axis
redundant? You can reflect different units in the axis title: "Weight
(lb) or Distance (miles)".
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Laura wrote:
> Barb,
>
> It seems that when I envoke the 2nd axis, it superimposes the one data
> series on top of the other. Ideally, I would like the scales to be the same
> on both axis, I just need to show that the units of measurment for the 2 data
> series were different. I suggested to our client to just add a footnote, but
> they definitely want 2 axis. Any thought?
>
> "Barb Reinhardt" wrote:
>
>
>>If you are using a secondary axis, check the scaling on both axes. You may
>>have it set so that you can't see one of the series.
>>
>>"Laura" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>I am creating a graph in Excel 2002. I have 2 data series and I need 2
>>
>>y-axis
>>
>>>due to different concentrations between the 2 data series. Everytime I try
>>
>>to
>>
>>>add the 2nd axis, I can only view one of the data series.
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks