Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |