Hello,
I spent some time decorating a PivotChart.
I would like to use a copy of the same PivotChart and base it on data from another similar PivotTable.
I could not do that because the Series of a PivotChart cannot be edited.
Any suggestion?
Thanks
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 when the PT updates, so does the PC?
Seems like it should be a simple solution, but I have had no luck with this.
Thanks in advance!
PS I am using Excel 2007, but I don't think that should matter
Hi all,
My worksheet contains about 12,000 rows in this format:
Item# -- Descrip -- Month -- Qty
123 -- Title #1 -- 1/1/2000 -- 100
123 -- Title #1 -- 2/1/2000 -- 105
123 -- Title #1 -- 1/1/2001 -- 26
125 -- Title #2 -- 1/1/2005 -- 57
125 -- Title #2 -- 2/1/2005 -- 25
and so on. I have a PivotTable/Chart that does what I want except for this: I would like to group the titles by their "launch date." If Title #1's first month is 1/1/2000 then it and all of it's data (including data in the next years) would go in the "year 2000 launch" category. Title #2 would go in the 2005 category, etc.
I could then show in my PivotChart a line graph for each "launch year."
Does that make sense? I'm very appreciative of any help.
Thank you.
It happens rather often that I want to plot numbers from a pivot table without using a pivot chart.
This is apparentlty impossible without duplicating the data from the pivottable to another (non-pivot) range (using simple formulas).
If there was however such a possibilty, I would be very glab to ear about it.
Thanks in advance ...
I have worksheet (SheetX) with a pivottable and associated pivotchart (Excel 2007). I allow users to copy SheetX to a new sheet (SheetY) where they can adjust the pivottable report for their needs; having done so they can copy SheetY to SheetZ, etc. All pivottables work of the same data - the aim is to allow the user to create a useful series/sequence of analyses of the data. My vba creates new sheets and renames the pivottable and pivotchart according to the new sheet name - BUT every copied pivotchart is linked to the same pivottable on SheetX - how do I use vba to point the pivotchart on SheetZ to the pivottable on SheetZ? Any advice appreciated - thanks.
Hi,
I have a PivotTable and below it, a Chart. The height of the PivotTable is
dynamic, depending on the data I filter on.
The problem I have is that if I put the chart too high up, it can happen
that the PivotTable will be displayed behind the chart (depending on what I
filter on). Is there a way to put the chart just below the PivotTable, and
having it move down automatically if the PivotTable need more rows? (or move
up if the PivotTable needs less rows)
Thanks.
Howdy All!
I've been working on a project in Access. It works fine, and exports tables to Excel. The number of records varies each time the Access file exports. Therefore, I've created a chart w/ dynamic ranges.
The chart works fine....It grows and shrinks accordingly. I'd like to include a line to show the average...dynamically. I found an equation that works w/ dynamic ranges. This function works well (found in cell C2).
However, I can't get that info turned into a line on my column chart. When I add that value into the chart, and change it to a line chart, I end up w/ one single data point. Understandably, because that's all there is.
Therein lies the question: How do I apply that value dynamically for each record so it shows as a line on my chart?
I've tried using trend lines, but they don't actually average...so they're not very helpful.
Attached is an example. Feel free to play w/ the data (add or remove as you will). The column chart changes accordingly, as does the average value in C2. But...I'd still like to get the average value to show as a line...
Thanks for the help.
I have a list of data shown in the data sheet.
I then have a chart and data table in the sheet Chart.
I am looking for a way of populating the data table in the sheet chart from counting the data in the Data Sheet.
I want to list the total number (column M) based on a criteria of Client (column D), Month (column F) and criteria Activity 1 (column G)
I have done this manually in the example, however, was looking to find the formula or code to do this automatically without using a PivotChart.
Thanks
McCrimmon
Hi all
I'm trying to create some "sparkline" type charts that show data over time.
My source data contains 3 columns (that are important for this) - date, country and value. For each country there are multiple records (one for each date).
I'm trying to create charts that will show how the value has varied over time for a specific country - the country(s) of interest is specified in a cell (on a separate "Dashboard" worksheet), which can change as new data is added each week (as it is chosen by ranking formulas which return best performing countries).
I can achieve this using pivot charts and appling a country filter, but I'm looking for a solution that doesn't need a pivot table, as there are going to end up being quite a lot of these charts.
Does anyone have any suggestions?
Cheers
Charlie
