pivot chart

  1. D

    Bubble Chart: Why is simple so hard?

    I have a very simple table of data... x-axis with "text definers" and y-axis with "text definers", and in the middle data... I just want to show a bubble chart with the x/y axis and the bubbles sized by the middle data. But, I can't define both axis. What am I missing? What can I use to do...
  2. Q

    Custom Filter Groups for Pivot Charts

    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...
  3. M

    Multiple Pivot Charts With Linked Filter

    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...
  4. S

    Chart set up

    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)...
  5. W

    VBA to allow use of Expand/Collapse button on Pivot Chart, but Disable all Formatting Selection

    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...
  6. P

    custom error bars in pivot chart based on calculated field

    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)...
  7. N

    Creating Pivot chart from Macro

    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...
  8. K

    Pivot Chart Color Theme Customization Possible?

    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...
  9. G

    Data labels in pivot chart

    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...
  10. A

    Getting Pivot Chart to change yearly goals into month according to filtered team

    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...
  11. J

    Multiple Summary pages

    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...
  12. K

    Show both text & numerical values in pivot chart

    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?
  13. S

    Creating a Pivot Chart without changing the table

    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...
  14. S

    Pivot Table with both % & Text - Showing 0 (zero)

    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...
  15. D

    Error Bars on pivot charts

    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...
  16. F

    Conditional Formatting for Bar Charts

    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...
  17. M

    Use Date Formula for Table Headers

    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...
  18. M

    Grand Total AVERAGE in Pivot Table

    <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...
  19. A

    Excel Pivot Chart - Group Small Amounts Together

    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...
  20. T

    Pivot Chart with VBA

    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...

Some videos you may like

This Week's Hot Topics