pivotchart

Hi all, I've inserted a pivot pie chart, which works great when filtering to show each column's (months) data in turn. However when I tick to include all columns in the Pivot Chart filter pane, it only shows the first column's (January) data. The title of the chart displays as January, too...

Hi everyone, I currently need to create around 1200 chart images using excel for a report series I am performing for a client. I have been trying all kinds of different things, all failures, to automate this process. My current method is to filter a pivot table on the building I am analyzing...

I have a single worksheet with multiple PivotTables, and I need to create a PivotChart for each of those PivotTables, 4 cells to the right of the top-left corner of the PivotTable. Any ideas? Scott

Hi, I have 2 charts. For example, Chart 1 and Chart 2 has different sales figure for northern and southern region. And both have Product category and sales quantity as slicer. Now it is a known fact that if I make selections in the slicer, both the charts gets automatically updated. I will...

I'm running a pivot table that has 3 columns worth of values. The pivotchart keeps defaulting to the leftmost column. If I want to see the other values in a chart, I have to move that dataset to the beginning. How can I fix this? Ideally, I'd like to be able to use the buttons on the chart to...

I am trying to make a PivotChart that has both a bar chart and a line chart in it. Along the x-axis I have 2008, 2009, 2010, 2011, 2012 forecast, 2013 plan, ytd 2012, and 2012 ytd plan. I want the data for 2008, 2009, 2010, 2011, 2012 forecast, and 2013 plan to be in a line chart and I want ytd...

Hi, after I created a Pivot Chart from a Pivot table, I like to keep the format of the Pivot Chart but want to change to a different Pivot table, how do I do that? this is what I tried: PivotChartTools - Design - Select Data, in the Select Data Source dialog box, Chart data range is gray out...

I'm looking for a way to automate some data manipulating. I have rows such as the below: Start Date------Days Supply------End Date------Unit 1/1/2011--------30-----------------1/31/2011-----540 I need to be able to chart this data by day (via PivotChart). Whereas, I need a column that would...

Hi, I am trying to copy out a worksheet to a new workbook. This worksheet includes a pivotchart and a pivotable, where the pivottable is the charts datasource. When i copy the sheet to a “New” book, the chart is no longer linked to the pivotchart and it remains static. As part of my cloning...

Hi all, I am creating a pivot chart in excel 07 from a table using 4 different columns: Week Number, Acronym, Employee, and Hours. I've got the week number and the employee in the legend, the acronym on the horizontal axis, and Sum of Hours as the values (vertical axis). The problem is, in the...

How can I create a PivotChart using VBA? I ran the macro recorder, and it referred to the source data in the standard way: ActiveChart.SetSourceData Source:=Range("'sheet1'!$A$3:$C$25") How do I create a chart that is specifically a PivotChart, referring to a PivotTable as a source, so that...

Hey everybody, I am working in 2007, and I do a lot of work with PivotCharts. We just switched from 2003 to 2007, and in 2003 I was able to filter data directly in the pivot chart by a drop down box in the upper left corner of the chart. I no longer have that functionality in 2007. Does...

Our application is based on MS SQL <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> We are now thinking to add “Business intelligence” cubes to our application<o:p></o:p> <o:p></o:p> We have created the necessary views in our SQL database which can be up to...

Hello - I am attempting to add a series on the xlSecondary axis of a PivotChart of BarStacked type. Please note that the data for the other series is not contained within the underlying PivotTable/ PivotCache. However, I am having difficulty in getting it to work. Attached is the relevant...