![excel pivot chart bubble excel pivot chart bubble](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Pivot-Chart-Example-1-15.png)
![excel pivot chart bubble excel pivot chart bubble](https://d13ot9o61jdzpp.cloudfront.net/images/edit_the_series.png)
My pivot table is doing just fine (it's a list of people to an event I'm organizing), but I'd like to add the information of a column I forgot to include days ago.
#Excel pivot chart bubble how to
However, I was wondering how to edit a pivot table, because I'm having troubles on a pivot table I created four days ago.
#Excel pivot chart bubble series
The chart’s Series formulas contain the original data, stored in arrays.
![excel pivot chart bubble excel pivot chart bubble](https://help.tableau.com/current/pro/desktop/en-us/Img/bubbles_5_10.0.png)
For this example, select a standard line chart and then click OK. Excel displays its Create Chart dialog box, from which you can choose a chart type. To create a pivot chart, select any cell in the pivot table and choose PivotTable Tools Options Tools PivotChart. The pivot table is certainly easier to interpret than the raw data, but the trends would be easier to spot in a chart. The Region field is in the Column Labels area. The Date field is in the Row Labels area, and the daily dates have been grouped into months. The first step is to create a pivot table to summarize the data. This data will be used to create a pivot chart. This workbook, named sales by region pivot chart.xlsx, is available on the companion CD-ROM. The Date field contains dates for the entire year (excluding weekends), the Region field contains the region name (Eastern, Southern, or Western), and the Sales field contains the sales amount.