If you need more than 256 columns, could you reorient the pivot table to use
256 rows instead? This will make for a rather crowded chart, won't it?
Working with dates, it will be better to use a single date column. You can
format a date to show just the day of the week (number format "ddd" for Mon,
Tues, etc., or "dddd" for Monday, Tuesday, etc.) or to include the day with
the date ("ddd dd.mmm.yy" for Mon 23 Oct 06).

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


"Scott" wrote in message
...
My COLUMN Headings are as follows:

Month-Day-Date-Sales-Discounts-Net, where Day is the day of the week, Mon.
Tues. etc.

I want my Page tabs in the Pivot Chart to be Month and Day.

My Chart Type is Stacked Column.

My Y Axes would be dollars, and my X axes would be the Date.

I would like to show Total Sales, with the amount of the discounts shown
on
the same "bar" with different color.

One of the issues, I believe, is the fact that Excel only has 255 columns,
where there are 365 days in the year. I believe this because I tried to
make
Sales a Series field, and received an error message.