mehmood said:
How to add straight line from cell value in pivot table chart.
If the data is not likely to update and the chart won't change, simply add a
line from Insert/Shapes (select the chart fist). If you are familiar with
VBA you could make a macro to move the line if/as required when the data
changes (possible but complicated).
A Pivot chart can only display series from the pivot data, you could add an
extra column of data all with same values (an average or target perhaps), ie
where you want your line to appear. If you've got a bar chart, select the
extra series and "Change Chart Type" to a Line type.
Alternatively create a normal chart based on the pivot data and add an extra
series with equal values. Similarly change the chart type of the extra
series to a Line type.
For both approaches to add a Line series in the chart, the source cells for
the line could link to your single cell.
Regards,
Peter T
