I have to create a graph holding 4 sets of data, two bar charts and two line
graphs. The other problem is that they are measured in different units - is
it even possible to plot this on a single chart?
Create a column chart of all four data series
Right click on one in the chart; select Chart Type and convert to line
Repeat with second data series
Right click one of the data series; Format Data Series and specify Secondary
y-axis
Repeat with second data series
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"PK" <PK@discussions.microsoft.com> wrote in message
news:219EBD7A-E126-4DFA-B528-A4B4CE39FDA5@microsoft.com...
>I have to create a graph holding 4 sets of data, two bar charts and two
>line
> graphs. The other problem is that they are measured in different units -
> is
> it even possible to plot this on a single chart?
I have four sets of data. One column is the major X axies and the second is
the Y axies. The third and fourth columns are data points the correspond
with each of the major axies. How do I graph this in an area chart or XY
scatter?
"Bernard Liengme" wrote:
> Create a column chart of all four data series
> Right click on one in the chart; select Chart Type and convert to line
> Repeat with second data series
> Right click one of the data series; Format Data Series and specify Secondary
> y-axis
> Repeat with second data series
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "PK" <PK@discussions.microsoft.com> wrote in message
> news:219EBD7A-E126-4DFA-B528-A4B4CE39FDA5@microsoft.com...
> >I have to create a graph holding 4 sets of data, two bar charts and two
> >line
> > graphs. The other problem is that they are measured in different units -
> > is
> > it even possible to plot this on a single chart?
>
>
>
Question
Reply
Top
Answer
Notify me of replies