Thank you Andy. Yep I walked right past the obvious.
"Andy Pope" wrote:
Hi,
Select the range A1:A4 and use the chart wizard to create a 100% stacked
column chart. At step 2 of the wizard select Series in Rows. This should
give you 1 column with 4 sections.
If I have mis-understood then post back.
Cheers
Andy
BRPtacek wrote:
I am looking to build a chart (do not care if it's cone, pyramid, column etc)
that takes a number of values and displays them as one image showing them
all. If I have the following cells with values such as A1=10, A2=20, A3=30,
A4=40. I want to get one image so that all values are shown with A4 having
40%, A3 having 30% and so on.
I am either walking past the obvious, but can't seem to get the wizards to
give me something other than 4 separate images, one for each value. I have
tried to adjust options but nothing seems to work.
Have looked at a few websites for examples but cant find any. I would
appreciate a push in the right direction.
Thank you Bob
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info