Changing chart types with series

M

miteeka

Hi,

I currently have a graph comprised of 4 different series. 2 of the series
are bar graphs, 2 others are line graphs. The problem is that one of the bar
graphs is overtop of the other bar graph meaning I can't see that series.
I've tried going in and changing it by changing the overlapped bar graph to a
line graph but I can't seem to do it. I've right clicked, selected chart
types but I can't change only 1 series of the graph. Is there anyway to do
this? Thanks,
 
M

miteeka

But how do I automatically turn the second bar graph into a line graph? This
will give me 1 bar graph and 3 line graphs in total. Thanks,
 
J

Jon Peltier

Don't use the built in custom type. Make the chart with all of one type,
like columns, then select one series, and use Chart menu > Chart Type to
change it to another type, like line.

- Jon
 

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

Top