I'm trying to create a multi-series chart/infograph to display total number of sales for the day as compared to the average. The chart consists of three series:
- Series 1: The base bar graph showing the number of each item sold
- Series 2: A scatterplot to overlay the icons for each item on the appropriate bar
- Series 3: Another scatterplot to overlay the average number of each of the items sold/day
The data is pulled from a SQL server and is automatically refreshed every 5 minutes using Excel's data connections properties.
I have a display in the office that has a PowerPoint running, showing various office events, etc. that I'd like to add this graph to. Typically I would just copy/paste into a slide in the presentation, maintain links, and call it a day. But therein lies the problem...
When I copy/paste into PowerPoint, only the first series is copied over for some reason. No worries, I thought, I'll just recreate the other two series in PowerPoint directly, linking to the data in Excel. This works until either file is saved/closed. Upon reopening, only the first series remains. For the Excel file, this happens for
.xlsb file types. How can I get charts with multiple series to save properly?
Note: I am using Excel 2016 and PowerPoint 2016