pivot chart

I have a bunch of pivot charts in a few different workbooks. I cannot get the legend to have the same formatting across workbooks. I have a bunch of series in the legend on a varying color scale. B is always red in workbook 1 legends. B is not and will not turn to red in workbook 2 legends...

I have a sheet that list orders going out for each day of the week and I have added a pivot table to summarize the quantities of each product for a given day. Since this is a template I would like to have a blank sheet with the various data fields for the day and off to the side have the pivot...

Disclaimer: This post is to meet the requirement for my college Spreadsheet Software Class ITE140. All responses are welcome but directed primarily towards my fellow students. Thank you Is there a way to incorporate images in the background of pivot charts and power view pivot charts?

Hi, I have an excel database from which I need certain data to be filtered and used for automating certain charts. Sample data is as shown below. I was wondering whether i could use a pivot to create a chart which has the cost covered and total cost as two stacked bars, the corresponding school...

I am using this code to create an embeded chart from pivot table. Dim pt As PivotTable Dim myChartObject As ChartObject Sheets("AOSTESUMMARY").Select Set pt = Sheets("AOSTESUMMARY").PivotTables(1) pt.TableRange1.Select Worksheets("AOSTESUMMARY").ChartObjects.Add Left:=500, Top:=500, Width:=300...

Hi Guys, I have a sheet of data which reflects e-mails that have come into a mailbox. Columns: Date, Category of e-mail, Time take to respond, SLA misses, Comments. (The table begins on A1 with the last column being F1). There are curerntly 50 rows of data. I want a piece of VBA code to...

Hi guys, I had created a piece of code which created a pivot table from a range of data into a new sheet. The code then create a pie chart from this data. For some reason I think I messed with the pivot table elementof the code and it no longer works. I keep receiving an error referring to...

Hi everyone I have trouble with Pivot Chart that's Slicer added. I wanted the Chart to look like certain type - for example Column and Line combo, however when something was picked wrongly in the slicer and reset - the chart went back to its default type.. Anyone knows who to fix this? Thanks

using Excel 2013... Thanks up front for any assistance from anyone! I have a pivot chart that whenever I start clicking through the timeline slicer it eventually (or immediately) returns to the original formatting. I have two values, one on primary and one on secondary axis, and I lose this...

I am building an exams analysis pivot table, dealing with GCSE Grades which comprise A*/A/B/C/D/E/F/G/U/X. I put the Subject Grade field in the Row Label and again in the Values to give a count of grade and all works well with all grades in the field being represented! However I want to show a...

Hi All Well this is my first question in MR EXCEL, hope I can explain better I have made a graph, which is taking a data from a table (please see the file from below link). The problem is; sometime there is no data in a series value, still excel take it as a blank-legend. I tried using NA() in...

I have the following 2 columns of pivot data:</br>Sent DateLead Time2/2/201562/2/201572/3/201522/3/201532/3/201552/3/201582/3/2015102/4/201542/4/201562/5/201532/5/201542/5/201552/5/201572/6/20156"Sent Date" is a filtered field. I want to plot the "Sent Date" on the X-Axis and the Lead Time on...

I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...

Hi everyone, I have a raw data of 70K lines and created a workbook with various worksheets based on their legal entities. Each worksheet has the same structure: multiple pivot tables and pivot charts. Therefore, when I first created them, I did the first tab and made copies for the rest. All I...

I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...

Hi, I need to use a combo box value in a report filter for a series of pivot tables. I have a combo box with a drop down list of suppliers on the dashboard front sheet and want to be able to select one of the values and then update all the pivot tables/charts with the report filter using that...

I'm creating a set of pivot table reports in Excel 2007 with a separate reporting dashboard sheet where I want to have a drop down selector for a specific field - supplier name which will drive all the pivot table reports on a the separate sheet and hence update the charts linked on the...

I have a Pivot that captures Project, amount of work remaining in days, days remaining in the project (project end date - now() ). I do not have any specific date fields to use in a series. I need a chart that shows something like a burn down (line chart). Dates till Project end date in...

I created a Pivot Chart in Excel 2010. I added a custom field (% Difference) to the pivot table. Now, the custom field shows on the Pivot chart. But, I do not want the custom field to show on the Pivot Chart. Any ideas how to accomplish this? I know that I can copy and paste values the Pivot...

Morning Chaps. Hope someone can help with this. I've a master workbook spooling off output reports using VBA, which are in effect slimmed down copies of the master workbook containing the source data, pivot tables with pivot charts & slicers - so looks & feels like a dynamic report for the...