how to change the axes.
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? |
how to change the axes.
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 |
how to change the axes.
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 |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com