combo chart conversion

A

Arturo

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
 
J

John Mansfield

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a line to a population bar chart 0
sideways stacked bar charts with line series on the same axis 0
Help with area under trendline 0
One extra x axis item that wont go away - can anyone help? 3
Chart data scrunches to left when adding X axis date series 0
Using the full width of an Excel chart with two Y-axes 2
Moving overlapping bars forwards and backwards 1
Odd Chart Format Results 1

Top