Hello,
I am trying to create a pivot chart with "Months as the x-axis, and count at the y-axis. (new to chart stuff - so bear with me)
I have the pivot table set-up fine except it truncated the x-axis if data are not present.
1)
Meaning if the count of ppl for January is 0, the x-axis begins with Feburary. Any way I can force it to start from January?
2) Also, is there any way to get rid of the "sum of people" etc tab that shows up in debug. I do not want that to turn up during printing.
Thank you.
RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave
I am trying to create a pivot chart with "Months as the x-axis, and count at the y-axis. (new to chart stuff - so bear with me)
I have the pivot table set-up fine except it truncated the x-axis if data are not present.
1)
Meaning if the count of ppl for January is 0, the x-axis begins with Feburary. Any way I can force it to start from January?
2) Also, is there any way to get rid of the "sum of people" etc tab that shows up in debug. I do not want that to turn up during printing.
Thank you.
RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave