P
Pfeif0
Hello,
My problem is clearly stated in the example below...
Example: I have 50 failure codes that have occurred throughout th
fiscal year, but only 5 to 7 of those 50 codes actually occur ever
month. In my macro I have to include all 10 codes because at some poin
in the year they will all occur. When I pull by month for the 20 lanes
am concerned about I want to know a way to only graph the 5-7 failur
codes that occurred that month (not all 50 where there will be som
blanks in the chart/graph).
Previous response:
Tools->Options. Then choose chart tab. I think the chart has to b
selected first
I think you want the "Not Plotted" option
Yes i am currently using that...it is checked but it is stil
generating the code as the x-axis when the zero is still not plotted.
I know how to suppress zeros in a graph, but when the zeros ar
suppressed how do you make the respective code that is on the x-aci
not show up so that the graph doesnt have these 50 codes on the botto
and only 5 bars with data. I want the 50 codes to drop to the only
that have a populated number so the graph is not huge.
Thanks as always,
Keith
My problem is clearly stated in the example below...
Example: I have 50 failure codes that have occurred throughout th
fiscal year, but only 5 to 7 of those 50 codes actually occur ever
month. In my macro I have to include all 10 codes because at some poin
in the year they will all occur. When I pull by month for the 20 lanes
am concerned about I want to know a way to only graph the 5-7 failur
codes that occurred that month (not all 50 where there will be som
blanks in the chart/graph).
Previous response:
Tools->Options. Then choose chart tab. I think the chart has to b
selected first
I think you want the "Not Plotted" option
Yes i am currently using that...it is checked but it is stil
generating the code as the x-axis when the zero is still not plotted.
I know how to suppress zeros in a graph, but when the zeros ar
suppressed how do you make the respective code that is on the x-aci
not show up so that the graph doesnt have these 50 codes on the botto
and only 5 bars with data. I want the 50 codes to drop to the only
that have a populated number so the graph is not huge.
Thanks as always,
Keith