Combine values into 1 chart image
 

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

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

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