Hi Andy

Becuase there are 15 groups that each have 2 sets of data (one is number,
the other is %) for each week, over several weeks the graph becomes hard to
read - there are so many lines and columns that matching the right column to
line becomes time consuming...I would really like to be able to attach the %
info the the correct column but it isn't looking right!

"Andy Pope" wrote:

Hi,

You can not combine chart types when using 3d styles.

What exactly is messy when you use a combination cluster column and line?

Cheers
Andy

soph wrote:
Hi

I have a lot of data that I need to chart, however I am trying to avoid it
looking too messy. I have 15 business units which have 2 pieces of data to
be compared for each week. I thought that a 3D graph would do it but it
still looks messy, and everytime I try to add a line as the 2nd piece of data
the graph reverts back to a 2D format. Can anyone suggest a better way of
graphing this?

Cheers
Soph

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info