pivot chart

I have a dataset with about 25 columns that I would like to visualize in a chart. Because of the large number of columns, having them all show up at once would make the chart too cluttered. Is there a way to create a custom filter for the chart to show predefined columns? For example, "show...

I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection. What I am trying to accomplish is I have all 3 pivot charts displayed...

Hello all, I was wondering if yall could help me with a chart organization problem that I have been having. I am not sure if it is better to set it up my charts as a pivot table or to use an original bar chart. On sheet one, I have in column A = names of employees, column B = Week of (Date)...

Hi! I have an obscure request. I do this thing where I like to use a pivot chart (with the expand/collapse button) as a fast way to "expand all" or "collapse all" for a related pivot table. Really, all I need is the Expand/Collapse button from the chart, so I always shrink the chart so I can...

Is it possible to create custom error bars in a pivot chart that are based on a calculated field? I would like to create a bar chart representing PROPORTIONS with error bars that represent the CONFIDENCE INTERVALS. My data contains N items that either can be "failed" (0) or "passed" (1)...

I have written a macro to create a Pivot chart in Excel in one Workbook. If I am running the macro from the same workbook it is adding the pivot chart proper without any error. But if I am running the macro from another workbook, I am getting the Application defined or Object defined error in...

Hey All, Just a quick question I cannot find an article or answer to. I have a table of data represented in pivot tables/charts. It covers several call center metrics in a line graph format (Calls Offered, Calls Answered, Calls Abandoned). I want to set a monochromatic color scheme / year...

Hi all, I have created a pivot chart (line graph) and would like the x-axis to display all months (Jan-Dec). The pivot table linked to the pivot chart formatted to show a running total for each month. So far I can either show only months that have data (i.e - if I have data for Jan-Mar, I can...

Hi Everyone, I have a data set of sales reps and their sales (date of sale, amount, team, etc). I also have a separate sheet which has goals for these folks for the full year. I've setup a pivot table and a line chart on the sales file that shows total sales for the year broken down by months...

Here is an example of a dashboard I created and I need help merging multiple dashboards into one PDF in excel. https://pasteboard.co/HNV3cgL.png This dashboard is a summary for one employee, but we have 50 employees. To change the employee to another, I am using a slicer, which then changes...

Hi! Trying to figure out a way to create a pivot chart where the value will show as "SUPP" if <= 9... anything >=10 will show the value... Any ideas?

Hi Everyone, I am just trying to make several pivot charts from one master pivot table I am using. each chart will refer to what is in the row. When I make a normal pivot chart and change the parameters within that, then it filters the pivot table and changes all the charts related to that. I...

My data table has several columns with both numbers, displayed as %, and Text. The text is: N/A. Please note, it is not #N/A, just simply N/A, and is text, not the result of a formula/function. When I pivot out the data table, the N/A are being shown as a 0 and thus 0.00%. I need to carry...

Hi I'm having some issues with error bars on a pivot chart I have created. The underlying data set is grouped into 3 separate materials. Each material has several repeat tests associated (so for example the table will have several rows of numerical data, with the first cell in each row...

Hello community, I created a table PivotChart where I am comparing expenses from this year and last year month by month. I would like my bars to be filled with a different color depending on the difference with the previous year. For instance, if I have spent more in January 2018 than I did in...

Hi everyone, I need help resolving the following issue: - Is there a way to force excel to read table headers as dates, and not text? More Info: - I converted my raw data source (a cross-tab formatted table with columns for each month) into an excel table, then converted that into a tabular...

<colgroup><col><col><col span="3"></colgroup><tbody> Hi there, Is there a way to make a pivot table include a Grand Total average? I want to average the totals by fiscal year not average each of the individual entries amounts. The cut and paste of the table is below, along with a handmade...

Hi, I am making a pivot chart (bar graph) to represent the number of transactions that happened in 196 plans. There are many plans with less than 3 transactions, and i would like to group them all together to be represented by a single bar called "All Other Plans". Is there a way to do this...

Hello, I recorded then altered the following code to create a pivot chart: Sub CreatePivotChart() ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlColumnStacked ActiveChart.SetSourceData Source:=Sheets("PivRetained").Range("A3:F34") ActiveChart.Location...

I'm struggling to do a few things with regards to developing actionable insights and presenting in an easy to use dashboard for a wide user group. The situation is as follows; I want to Create a hierarchy dashboard across a number of kpis. I.,e start at the president's view of the average...