P
PowerPoint Jedi
I managed to creat a pivot chart with some data I have. It represents the
number of falures of multiple items over the period of 12 month. Currently I
have the data plotted as the count failures over the 12 months per part. in
other words my Y-axis is part number and my x-axis is number of failures.
The data field is the count over the year. What I would like to do is show
both the count of the whole year and the count for one month per part. In
other words for each y-axis part i would like to have 2 bars one representing
the 12 month total one representing the most recent total. My problem is
that when I select month as a second data field parameter and limit it to 1
month it effect my yealy total also. is there a way to do a comparitve bar
graph. I realize this is long so if you have question feel free to ask. I
will be checking frequently.
number of falures of multiple items over the period of 12 month. Currently I
have the data plotted as the count failures over the 12 months per part. in
other words my Y-axis is part number and my x-axis is number of failures.
The data field is the count over the year. What I would like to do is show
both the count of the whole year and the count for one month per part. In
other words for each y-axis part i would like to have 2 bars one representing
the 12 month total one representing the most recent total. My problem is
that when I select month as a second data field parameter and limit it to 1
month it effect my yealy total also. is there a way to do a comparitve bar
graph. I realize this is long so if you have question feel free to ask. I
will be checking frequently.