Chart - Line Column on 2 Axes Question

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

Hello,

I created a line column chart on 2 axis. I have four data
sets. The first 3 should go on the primary Y axis as
columns and the 4th should go on the secondary Y axis as a
line. However, Excel wants to automatically put both the
3rd and 4th data sets on the secondary axis as lines. I
cannot find any command to change the 3rd data set to go
onto the primary axis as a column.

Any suggestions would be most appreciated!

-Patty
 
Hello,

I created a line column chart on 2 axis. I have four data
sets. The first 3 should go on the primary Y axis as
columns and the 4th should go on the secondary Y axis as a
line. However, Excel wants to automatically put both the
3rd and 4th data sets on the secondary axis as lines. I
cannot find any command to change the 3rd data set to go
onto the primary axis as a column.

Any suggestions would be most appreciated!

-Patty
Click to expand...

Select the third data set, go to the menu and click Format | Selected data
series | Axis tab. Select the primary axis.

With the third data set selected, click Chart | Chart Type and pick the
appropriate column type.
 
Thanks Dave! I didn't know about your second suggestion,
that you could change how a particular data set is viewed.
Appreciate your help!
 
Back
Top