Super User
Super User

Questions tagged [pivot-chart]

68 questions
6
votes
1 answer

Can I convert a list of names directly into a pie chart in Excel?

I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like: Abrams Abrams Butler Cromwell Cromwell Cromwell Edison…
JeanSibelius
  • 387
4
votes
9 answers

Excel chart formatting lost when Refresh All or individual Right Click on Data > Refresh

I have 4 pivot charts that rely on data that is refreshed from a connection. When I click refresh all I lose all the formatting I set up (colours/borders/line and bar and 2nd axis choices) I have already unchecked Properties Follow Chart Data…
Matt
  • 97
3
votes
1 answer

Remove Line in Pivot Chart for Blanks

How do I get the forecast to not show the flat line in the past and also the actual to now show the flat line in the future?
Steve Britton
  • 31
3
votes
1 answer

Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?

I am working with data in groups in Excel. I currently have a pivot table and chart set up with: Rows: symptom name grouped into one of four international severity grades Columns: four datasets - mild, severe, both or not specified. I need to…
Rory
  • 615
2
votes
0 answers

Change PivotChart source from one PivotTable (external data source) to another PivotTable (table/range)

I have a PivotChart in Excel 2016 that is currently based on PivotTable-A. PivotTables A and B are identical, other than the fact that they have different data sources: A's data source is an external data source connection. B's data source is an…
User1974
  • 185
2
votes
2 answers

Excel: Create truly blank cells from formula so that they wont show up in a pivot table?

So I've had a look at similar answers but they're not working for me. Basically I have a lot of related charts of monthly data, and I'm wanting to plot them on a chart that only shows up the current year's data and shows some "target" points for…
CORCSIR
  • 21
2
votes
0 answers

Run Excel Macro when Slicer is Clicked

I have a PivotTable connected to a Horizontal Bar Chart. When I filter the content to be displayed in the Chart (by using the Slicer), the Chart did not resize according to the entries displayed. This made the bars either become HUGE or too small.…
Sybrand E. Smit
  • 21
2
votes
1 answer

Excel: Pivot chart of values using value-stdDev as error bars?

I have a table of measurements, with each data point being measured multiple times. I would like to create a PivotChart which displays the average value and uses the value's standard deviation as error-bars. This is what I have so far: My…
BmyGuest
  • 456
2
votes
1 answer

How can I combine chart categories in Microsoft Excel?

If I have some categories e.g. 'Chicken', 'Moose' and 'Pork', how can I combine them into one 'Meat' category (and others into different categories e.g. 'Seafood')? I would also want to show how much of the 'Meat' and 'Seafood' are "fresh" and…
pilti
  • 21
2
votes
3 answers

Excel Pivot with percentage and count on bar graph

Is it possible to create a Pivot bar graph that Shows percentage and Count in the same bar? I only have Excel 2010 MWE: Firm Product 1 Car 2 Ship 3 Car 4 Ship 5 Car I can easily create a Pivot table / charte using Product in the value…
Max M
  • 125
2
votes
1 answer

How to remove a duplicate value on slicer in Excel

I am trying to build a pivot table to compare some data. I first made a Excel sheet for my colleagues to enter their respective data, expecting that discrepancies when they enter the data, I used drop down lists for all the standard input like,…
Gobabis
  • 121
  • 1
  • 1
  • 4
2
votes
3 answers

How to connect existing slicers to new pivot charts?

I had 6 existing slicers connected to 4 pivot charts. I created a new pivot pie chart and want to connect 5 of the 6 existing slicers to it but I can't do so. The only thing I can do is create 5 new slicers which I don't want to do. As can be seen,…
Gaurav Lakhotia
  • 55
2
votes
0 answers

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally copy the data displayed into a new sheet and…
Tahlor
  • 165
1
vote
0 answers

Excel how to group up data by percentages

I have a graph which many Series, but I only need the first 5 and I want to group up the rest as a Series of its own called "others". Here you can see how all the smaller data below the top 6 agglomerate with each other. On the Pivot table I tried…
Camilo Enriquez
  • 11
1
vote
1 answer

Force bar chart to show missing years within 10-year range (system year + 9)

I have a table in Excel 2016: YEAR_ AMOUNT ---------- ---------- 2024 100 2025 200 2025 300 2026 400 2027 500 2028 600 2028 700 2028 …
User1974
  • 185
1
2 3 4 5