Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
One bar chart
Hello,
I am looking to create a chart in one column but with all values, like the pie charts sixth option but for the whole of the chart should be be the blocks and no pie. The figures I need to put in is a number of participant for an event and I would like to show the highest number of participant on top with the biggest block and the fewest in the bottom with the smallest block. The country and number of participants whould be labelled in the blocks. See sample numbers below. Iceland 20 United Kingdom 16 Netherlands 13 Norway 13 Sweden 11 Finland 9 Denmark 9 Belgium 7 Ireland 5 Italy 1 So the biggest block will be Iceland and the smallest Italy in this case. Your contribution is much appreciated. Thanks, Rene |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
One bar chart
1) Sort the data so that the LOWEST value is at top
2) Select the Country Names and numbers; make a stacked Column Chart (second sub-type) If you use "Press and Hold to View Sample" at this stage you will NOT see what you want but persevere, we will fix that. 3) Click Next and in Step 2 of Chart Wizard, on the Data Range tab, specify the data is in ROWS 4) Finish the wizard (remove legend, if you like) 5) Format each 'block' in the chart - each one is a Series to add Data Labels. Drag the label to wherever you want it. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Rene Petersen" wrote in message ... Hello, I am looking to create a chart in one column but with all values, like the pie charts sixth option but for the whole of the chart should be be the blocks and no pie. The figures I need to put in is a number of participant for an event and I would like to show the highest number of participant on top with the biggest block and the fewest in the bottom with the smallest block. The country and number of participants whould be labelled in the blocks. See sample numbers below. Iceland 20 United Kingdom 16 Netherlands 13 Norway 13 Sweden 11 Finland 9 Denmark 9 Belgium 7 Ireland 5 Italy 1 So the biggest block will be Iceland and the smallest Italy in this case. Your contribution is much appreciated. Thanks, Rene |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
One bar chart
Thank you Bernard.
Have a great day. Regards, Rene "Bernard Liengme" wrote: 1) Sort the data so that the LOWEST value is at top 2) Select the Country Names and numbers; make a stacked Column Chart (second sub-type) If you use "Press and Hold to View Sample" at this stage you will NOT see what you want but persevere, we will fix that. 3) Click Next and in Step 2 of Chart Wizard, on the Data Range tab, specify the data is in ROWS 4) Finish the wizard (remove legend, if you like) 5) Format each 'block' in the chart - each one is a Series to add Data Labels. Drag the label to wherever you want it. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Rene Petersen" wrote in message ... Hello, I am looking to create a chart in one column but with all values, like the pie charts sixth option but for the whole of the chart should be be the blocks and no pie. The figures I need to put in is a number of participant for an event and I would like to show the highest number of participant on top with the biggest block and the fewest in the bottom with the smallest block. The country and number of participants whould be labelled in the blocks. See sample numbers below. Iceland 20 United Kingdom 16 Netherlands 13 Norway 13 Sweden 11 Finland 9 Denmark 9 Belgium 7 Ireland 5 Italy 1 So the biggest block will be Iceland and the smallest Italy in this case. Your contribution is much appreciated. Thanks, Rene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |