S
shadestreet
Some quick questions on pivot tables:
1. How can I preserve the formatting of my pivot-reports? After i
update the column width, wrap-text features are refreshed as well. I
checked the "table settings" option and un-checked "Auto Format", but
this still happens?
2. I setup a workbook with 6 pivot tables drawing upon 1 set of source
data (2 pages are pivot report, 4 are pivot charts). I designed this
looking at some information for month-to-date of April, once I was
comfortable with my results I saved a copy to be used as a template for
each month. Next I pulled information for the month of March, pasted it
into my input page, and refreshed each of the 6 pages. Everything seems
to work fine except for two problems:
First, most of the graphs have the X-axis using the "Date" field.
While the graph displays 3/1, 3/2/, 3/3, 3/4, etc for the month of
March, when I click on the "Date" box it only lists me the first 14
days of April-which were the first days available when I made the
original report to be used as a template. I tried pulling the date
field off the chart, then adding it back in but that didn't correct
this minor bug. Any help on this?
Second, one of the charts doesnt populate any information... I
have to recreate it.
If it helps, my source data is a single excel page that uses all rows
in columns A through U.
1. How can I preserve the formatting of my pivot-reports? After i
update the column width, wrap-text features are refreshed as well. I
checked the "table settings" option and un-checked "Auto Format", but
this still happens?
2. I setup a workbook with 6 pivot tables drawing upon 1 set of source
data (2 pages are pivot report, 4 are pivot charts). I designed this
looking at some information for month-to-date of April, once I was
comfortable with my results I saved a copy to be used as a template for
each month. Next I pulled information for the month of March, pasted it
into my input page, and refreshed each of the 6 pages. Everything seems
to work fine except for two problems:
First, most of the graphs have the X-axis using the "Date" field.
While the graph displays 3/1, 3/2/, 3/3, 3/4, etc for the month of
March, when I click on the "Date" box it only lists me the first 14
days of April-which were the first days available when I made the
original report to be used as a template. I tried pulling the date
field off the chart, then adding it back in but that didn't correct
this minor bug. Any help on this?
Second, one of the charts doesnt populate any information... I
have to recreate it.
If it helps, my source data is a single excel page that uses all rows
in columns A through U.