ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data points (https://www.excelbanter.com/charts-charting-excel/254144-data-points.html)

Bill Mc

Data points
 
In 2003 I could grab a data point on the chart and move it causing the value
in the data table to adjust to match the position on the chart.

Is this interactive capability gone in 2007?
--
Bill Mc.

David Biddulph[_2_]

Data points
 
Yes.
--
David Biddulph

"Bill Mc" wrote in message
...
In 2003 I could grab a data point on the chart and move it causing the
value
in the data table to adjust to match the position on the chart.

Is this interactive capability gone in 2007?
--
Bill Mc.




Andy Pope

Data points
 
Hi,

There is a replacement Addin.

http://blogs.msdn.com/excel/archive/...arts-mpoc.aspx

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bill Mc" wrote in message
...
In 2003 I could grab a data point on the chart and move it causing the
value
in the data table to adjust to match the position on the chart.

Is this interactive capability gone in 2007?
--
Bill Mc.



Bernard Liengme[_2_]

Data points
 
Yes it has gone the way of the dodo. Many of us asked for it back and kindly
Microsoft responded with a great add-on: Excel Add-In for Manipulating
Points on Charts (MPOC)
Do not let the mention of Excel 2010 out you off - in works in Excel 2007
as well as the article mentions.
Read this to see if ti is what you want
http://blogs.msdn.com/excel/archive/...arts-mpoc.aspx

Go here to get it (look at the bottom where you agree to the EULA)
http://blogs.msdn.com/excel/pages/EU...-On-Chart.aspx


best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Bill Mc" wrote in message
...
In 2003 I could grab a data point on the chart and move it causing the
value
in the data table to adjust to match the position on the chart.

Is this interactive capability gone in 2007?
--
Bill Mc.




All times are GMT +1. The time now is 03:47 PM.

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