pivot charts

I have some data that I'd like to put into a Line Pivot Chart. The data is as follows: 1/1/10 Location 1 98% 1/1/10 Location 2 95% 2/1/10 Location 1 97% 2/1/10 Location 2 93% 3/1/10 Location 1 97% 3/1/10 Location 2 98% etc. I'd like to have the months as the x axis of...

Hi, in older Excel versions when you create a pivot chart there were all fields shown as dropdowns in the Chart. So when you print it you can for example see if there are filters present. In Excel 2007 I cannot find these in pivot charts anymore. Does anybody know how to show the filters in...

I'm trying to create a Pivot Chart (have created actually) that has two page views: 1) District and 2) Customer Name. I want a user to be able to choose their district and only the applicable customers related to their district show up in the list. Right now, all customers across all districts...

I am trying to create a chart on each sheet. my method was to use pivot table/chart and then whan the sheet was copied the table/chart would get updated with the new data. Not So so I am now trying the same thing but on a button. I recorded a macro and am now trying to modify it by changing...

Hi All<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am new to pivot tables and using charts so my questions are fairly basic, I have tried to explain them as best as I can but if you need further explanation please just ask.<o:p></o:p>...

Good Morning, I have several custom chart formats applied to pivot charts that require distribution but as you all know in Excel 2003 the formats revert back to the default chart as soon as someone interacts with the chart or the underlying pivot table. I can easily create a macro on my own PC...

I have developed a pretty large VBA project which started to eat up more and more memory as it runs, so I am interested in finding various methods to stop the flood. Some background info: - the project imports data from a variety of sources: HTML files, Thunderbird local folders, e-mail messages...

My manager would like me to create charts for 30+ departments every month in separate files with their average weekly spend for the past year and headcount. There are sub-departments that I've been using in the page field of a pivot chart so the manager can view total spend, or spend by...

I have a survey with 6 different groups and 22 questions/sheets (one survey question per sheet). I would like to show the individual group their survey results and the grand total. I am having trouble getting the grand total to show on the pivot chart. I would also like to filter this for all...

I am trying to copy and paste a Pivot Chart multiple times, to save the effort of recreating it. I'm having 2 main problems: - If I copy and paste just the chart, I do not see the corresponding pivot table to alter the copied chart. - If I copy and paste the pivot table, changing the...

Hey, My company recently switched from Microsoft 2003 to 2007. I use a lot of PivotTables and PivotCharts. In the 2003 version, I was able to have a drop down box in the actual PivotChart, and now I do not have that functionality. Now to filter, I have to go a long ways around to filter my...

How do I prevent the format of my pivot charts from changing. Every time I refresh my pivot chart the format returns the default?