I have created a chart in Excel using a pivot table. The chart I am using is
2 axes, bar and line and I am using 3 sets of data. One of which I want as a
bar and the other 2 as lines. It defaults to the other way around ie 2 bars
and one line. The data I wish to switch to a line is so small that I can't
click on it and change to secondary axix. is there another way to do it?

In article , ?B?
RWRnYXIgSmFtZXM=?= <Edgar says...
I have created a chart in Excel using a pivot table. The chart I am using is
2 axes, bar and line and I am using 3 sets of data. One of which I want as a
bar and the other 2 as lines. It defaults to the other way around ie 2 bars
and one line. The data I wish to switch to a line is so small that I can't
click on it and change to secondary axix. is there another way to do it?

Option 1: Select any of the series that you can. Then, use the up/down
arrow keys until XL selects the desired series.

Option 2: Select any chart element. The Chart toolbar will become visible.
Use the dropdown box on the left to select the desired series.

In either case, once you select the series, use Format | Selected Data
Series...
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Tushar

Many thanks. It works!

"Tushar Mehta" wrote:

In article , ?B?
RWRnYXIgSmFtZXM=?= <Edgar says...
I have created a chart in Excel using a pivot table. The chart I am using is
2 axes, bar and line and I am using 3 sets of data. One of which I want as a
bar and the other 2 as lines. It defaults to the other way around ie 2 bars
and one line. The data I wish to switch to a line is so small that I can't
click on it and change to secondary axix. is there another way to do it?

Option 1: Select any of the series that you can. Then, use the up/down
arrow keys until XL selects the desired series.

Option 2: Select any chart element. The Chart toolbar will become visible.
Use the dropdown box on the left to select the desired series.

In either case, once you select the series, use Format | Selected Data
Series...
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Tushar

Many thanks. It works!

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions