View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default combining 3D with lines

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