Plotting large sales ranges on bar graph

[wsnyder]

Hi all,


Starting a new dashboard

I have a large range of sales where 1 unit is 197K and another unit might by 1.3K


Due the range of values I am afraid it may not translate meaningfully to a bar graph

I've loaded my initial workbook here:


http://cid-fb86d3d43fbd123b.skydrive.live.com/self.aspx/.Public/Sales%20Bar.xls


Appreciate any thoughts/comments


Kind regards,

Winston

 

[Alex]

This problem annoys me.


The best work around that I've found is to make two graphs, same size, same data. Put them above one another and remove the x-axis labels from the top one. Then specify the values of the y axises so that one is small numbers (say, 1-5) and then the other is high numbers (80- 150). know what i mean? It is the same as inserting a break i the y axis, but unofficial.


I can upload an example at work on monday if you like. But there may be better unofficial answers some where else.

 

[Hui]

Winston


have a read of http://chandoo.org/wp/2010/05/12/introduction-to-panel-charts-using-excel-tutorial-template/

and the follow up comments