Thread: 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 can’t 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 can’t 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 can’t find any. I would
> > appreciate a push in the right direction.
> >
> > Thank you Bob
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>