Ignore Y axis value
 

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?

Ignore Y axis value
 

That's called a table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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?

Ignore Y axis value
 

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" wrote:

That's called a table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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?

Ignore Y axis value
 

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/ChartsH...ierLabels.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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" wrote:

That's called a table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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?