combo chart conversion
Hello
2 questions. 1. I have a line chart, 4 series 2 axis. I want to switch two of the series associated with one axis to bars side by side. When I switch the second series, it overlaps the first. Perplexed as to why they won't stand side by side. 2. This chart is an object in a sheet, how do I get it as a chart sheet also? Appreciatively, Arturo |
Arturo,
Please make sure that you are using the Clustered Column chart option - it should work then. To turn the embedded chart into a chart sheet, click on the chart to activate it. Right-click on your mouse and choose "Location". You can also make a copy the embedded chart and turn it into a chart sheet. That way you will have an embedded chart identical to the chart sheet that you just created. ---- Regards, John Mansfield http://www.pdbook.com "Arturo" wrote: Hello 2 questions. 1. I have a line chart, 4 series 2 axis. I want to switch two of the series associated with one axis to bars side by side. When I switch the second series, it overlaps the first. Perplexed as to why they won't stand side by side. 2. This chart is an object in a sheet, how do I get it as a chart sheet also? Appreciatively, Arturo |
All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com