ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I alter the value of a data point in a chart series (https://www.excelbanter.com/charts-charting-excel/207496-how-do-i-alter-value-data-point-chart-series.html)

IanU

How do I alter the value of a data point in a chart series
 
How do I alter the value of a data point in a chart series

Jon Peltier

How do I alter the value of a data point in a chart series
 
You can change the value in the cell that the point represents.

In Excel 2003 and earlier, you can select the point (single click to select
the series, then single click again to select the point), then when the
cursor turns into a double or quadruple arrow, click on the point and drag
it. This capability was removed from Excel 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"IanU" wrote in message
...
How do I alter the value of a data point in a chart series





All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com