Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default Removing Points from Chart.

Hi,
is it possible to click and remove data points from the chart manually.

I would like to remove some points that are not close to my trendline or
best fit line i have created on the chart, and at the same time i want them
to get removed from the cells (where I have the data table).

Is this possible? How? Please Help. Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default Removing Points from Chart.

I'm afraid that is not possible
In pre-2007 versions you can drag a point on an XY chart to a new position
BTW: do be aware that it you remove data points, the trendline will also
shift
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Raz" wrote in message
...
Hi,
is it possible to click and remove data points from the chart manually.

I would like to remove some points that are not close to my trendline or
best fit line i have created on the chart, and at the same time i want
them
to get removed from the cells (where I have the data table).

Is this possible? How? Please Help. Thanks in advance.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Plot lines between plot points on a line chart JDKapono24 Charts and Charting in Excel 2 April 2nd 23 07:07 PM
HELP!!!!!!!!!! Y By X Chart with points. Curt Hand Charts and Charting in Excel 3 August 29th 06 03:15 PM
how do i add lable to the points in the chart, arash Excel Discussion (Misc queries) 1 May 11th 06 01:07 PM
Bar Chart To Line Chart for last 3 points only Big H Charts and Charting in Excel 1 October 13th 05 09:55 PM
Removing/adding decimal points Lou Excel Discussion (Misc queries) 2 March 2nd 05 08:56 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"