Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
How to omit data in a chart when there are error values? | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |