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

On Tue, 11 Nov 2003 13:27:33 -0800, Patty
<(E-Mail Removed)> wrote:

> 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

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.

--
Dave
dvt at psu dot edu

Thanks Dave! I didn't know about your second suggestion,
that you could change how a particular data set is viewed.
Appreciate your help!
>-----Original Message-----
>On Tue, 11 Nov 2003 13:27:33 -0800, Patty
><(E-Mail Removed)> wrote:
>
>> 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
>
>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.
>
>--
>Dave
>dvt at psu dot edu
>.
>