If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Chart - Can the category axis show weekly data broken into months, or just week numbers?
I have a pivot chart tracking my sales for the year, and each bar is
numbered along the category axis by week number (so there are 52 bars, with the one for the first week of January marked "1", and the one for this week marked "51"). Is there any way to have these broken into months somehow, because if I want to see how I did in May, I'm not exactly sure which weeks to look at without thinking about it. To be clear, I want a bar for each week, I'm not trying to get 12 bars with one for each month. Any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it possible to plot this kind of data in a (line) chart w/ preferred axis? How? | pgtr | General Discussion | 4 | September 15th, 2004 02:05 AM |
Broken links don't show old data. Help! | Marky Mark | Links and Linking | 0 | October 21st, 2003 02:03 AM |
2 Axis Pivot Table Based Chart Problem | Ted Pearlman | Charts and Charting | 1 | October 3rd, 2003 11:16 PM |
Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap | Viper | Charts and Charting | 1 | September 28th, 2003 02:31 AM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |