Ignore Y axis value

[Neil]

I have 4 facilities 901, 960, 972, and 990 that share 4 departments Pulling,
Shipping, Receiving, and Stocking that are graded on 4 criteria UPH,
Overtime%, IndirectLabor%, and Performance%.

I want a 1 bar graph for each department that compares each faclities
criteria in 4 sections. My problem is the UPH is in the thousands and the
Indirect is less than 10. So, in my graph I can not see the smaller numbers
in each sectioin.

Is there a way to have a bar graph that only shows the values on each bar
without regard to a Y axis?

 

[Jon Peltier]

That's called a table.

- Jon

 

[Neil]

Thanks! Now how do I represent it graphically? Again the problem is the
large numbers don't allow the very small ones to be shown in the bar graph.
There is no way to plot on second axis.

 

[Jon Peltier]

You have to fake it. You can try to produce a chart with a broken Y axis
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

or max out the Y axis at a value that allows the shorter series to be
legible, with some kind of indicators
http://peltiertech.com/Excel/ChartsHowTo/OutlierLabels.html

- Jon