Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
Hi,
I have to plot budget performance of different units in a chart. The issue is that one of the unit is in miilons ( big figures while the other units is in thousands (small amounts) If i sekect the proper scale in a bar chart one of them is too small to be visible. I tried to use logarthmatic scale, but it is not giving a clear picture. Like when the achievement for the smaller figured bar chart portion is 50 % the chart look like something like 90 %. Is there a better way to present this? or use different scale for the data for different bar? My dat look like this Category Budget Actual A 365,000,000 395,000,000 B 207,000,000 275,000,000 C 10,000,000 5,000,000 D 4,000,000 6,000,000 Hoe can I present this in a bar chart ? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
One possible solution is to put your chart into Landscape format and then
drag the chart out as far as possible to the right hand side. If you do this the, "lower" numbers are clearly visible. Please hit Yes if my comments have helped. Thanks. "Abdul" wrote: Hi, I have to plot budget performance of different units in a chart. The issue is that one of the unit is in miilons ( big figures while the other units is in thousands (small amounts) If i sekect the proper scale in a bar chart one of them is too small to be visible. I tried to use logarthmatic scale, but it is not giving a clear picture. Like when the achievement for the smaller figured bar chart portion is 50 % the chart look like something like 90 %. Is there a better way to present this? or use different scale for the data for different bar? My dat look like this Category Budget Actual A 365,000,000 395,000,000 B 207,000,000 275,000,000 C 10,000,000 5,000,000 D 4,000,000 6,000,000 Hoe can I present this in a bar chart ? Thanks . |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
Put one data series on a secondary Y axis
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Abdul" wrote in message ... Hi, I have to plot budget performance of different units in a chart. The issue is that one of the unit is in miilons ( big figures while the other units is in thousands (small amounts) If i sekect the proper scale in a bar chart one of them is too small to be visible. I tried to use logarthmatic scale, but it is not giving a clear picture. Like when the achievement for the smaller figured bar chart portion is 50 % the chart look like something like 90 %. Is there a better way to present this? or use different scale for the data for different bar? My dat look like this Category Budget Actual A 365,000,000 395,000,000 B 207,000,000 275,000,000 C 10,000,000 5,000,000 D 4,000,000 6,000,000 Hoe can I present this in a bar chart ? Thanks |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
Hi Bernard,
Could you please explain further from the above examle data. thanks |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
Right click one data series on the chart and select Format Data Series
Depending on what version of Excel you are using there will be an option somewhere to use a secondary axis for this data series. The secondary axis will be on the right-hand side of the chart and will automatically get a suitable (or near suitable) scale. best wishes Bernard "Abdul" wrote in message ... Hi Bernard, Could you please explain further from the above examle data. thanks |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
I reckon that doesn't work with the data that has been provided.
"Bernard Liengme" wrote: Right click one data series on the chart and select Format Data Series Depending on what version of Excel you are using there will be an option somewhere to use a secondary axis for this data series. The secondary axis will be on the right-hand side of the chart and will automatically get a suitable (or near suitable) scale. best wishes Bernard "Abdul" wrote in message ... Hi Bernard, Could you please explain further from the above examle data. thanks . |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
What data was 'provided' ?
Bernard "trip_to_tokyo" wrote in message ... I reckon that doesn't work with the data that has been provided. "Bernard Liengme" wrote: Right click one data series on the chart and select Format Data Series Depending on what version of Excel you are using there will be an option somewhere to use a secondary axis for this data series. The secondary axis will be on the right-hand side of the chart and will automatically get a suitable (or near suitable) scale. best wishes Bernard "Abdul" wrote in message ... Hi Bernard, Could you please explain further from the above examle data. thanks . |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
See Abdul's original posting.
"Bernard Liengme" wrote: What data was 'provided' ? Bernard "trip_to_tokyo" wrote in message ... I reckon that doesn't work with the data that has been provided. "Bernard Liengme" wrote: Right click one data series on the chart and select Format Data Series Depending on what version of Excel you are using there will be an option somewhere to use a secondary axis for this data series. The secondary axis will be on the right-hand side of the chart and will automatically get a suitable (or near suitable) scale. best wishes Bernard "Abdul" wrote in message ... Hi Bernard, Could you please explain further from the above examle data. thanks . . |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with un even data
Hi,
You could try the broken axis approach. http://www.andypope.info/charts/brokencolumn.htm For me your example data produces small but visible column/bars for the categories C+D. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Abdul" wrote in message ... Hi, I have to plot budget performance of different units in a chart. The issue is that one of the unit is in miilons ( big figures while the other units is in thousands (small amounts) If i sekect the proper scale in a bar chart one of them is too small to be visible. I tried to use logarthmatic scale, but it is not giving a clear picture. Like when the achievement for the smaller figured bar chart portion is 50 % the chart look like something like 90 %. Is there a better way to present this? or use different scale for the data for different bar? My dat look like this Category Budget Actual A 365,000,000 395,000,000 B 207,000,000 275,000,000 C 10,000,000 5,000,000 D 4,000,000 6,000,000 Hoe can I present this in a bar chart ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel |