Forum Discussion
Excel Pivot Chart vertical dynamic line
The problem here is when you switch to Pivot combo chart, It doesn't have the “Scatter with Straight Lines” options at all. That's why I took shelter of this forum.
If I understood correctly...
You have followed the instructions to create a combination chart and change the chart type of the dynamic value data series to “Scatter with Straight Lines” but you are unable to find this option in the “Change Chart Type” dialog box.
It seems that you are unable to find the “Scatter with Straight Lines” option when trying to change the chart type of the dynamic value data series in a pivot chart. I also don't know if this is possible as desired, there are other specialists in this forum who know a lot better.
The only thing I can offer here…
One possible workaround is to insert an XY Scatter chart in a blank cell a few rows or columns away from the pivot table.
Right-click on the chart and choose “Edit Data”.
Add a new series and select the ranges with the series name, X values, and Y values.
This chart should update automatically if the pivot table data is refreshed.