In a particular workbook I have a Pivot Chart which has been moved to a separate Sheet. The X-Axis consists only of Dates. Navigate to the Chart sheet. Select the field from the Axis Fields box and
I have upgraded from Excel 2003 to 2007. The pivot chart filter used to appear on the chart. Now it appears on a seperate dialog box. This gave a useful heading. Now I have to edit a text box every
My filter for my pivot table is in cell A2 and it's a value for a store number. I have a pivot chart tied to the pivot table. When I filter by store# (i.e. store# 300), how do I get the pivot chart to
Excel 2003 ... My Pivot Chart X-Axis Title is obscured by the Pivot Chart Filter Buttons ... I can see very top part of the Title, but it is behind the Buttons & also does not display on