Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How to add straight line from cell value in pivot table chart.
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "mehmood" wrote in message 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Add straight line to chart | Charts and Charting in Excel | |||
How to add straight line from cell value in pivot table chart. | Excel Worksheet Functions | |||
How do I fit a straight line to scatter diagram chart data | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
straight line connecting first and last point on a chart | Excel Programming |