Data points

B

Bill Mc

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?
 
B

Bernard Liengme

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...n-for-manipulating-points-on-charts-mpoc.aspx

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


best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving a line chart data point revises data table value in Excel ' 1
How do I adjust table data by moving chart points? 1
Add second string of data to existing chart 1
Stopping a chart when the data runs out 9
How to have data labels follow time adjusting line charts? 0
Moving chart points 2
Chart Wizard 5
Format Charts as Object 3

Top