Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
can i edit only a selected range of data in an excel chart?
I perform a lot of tests that involve changing changing an element during the
run and observing the effects over time and it would be extremely useful if I could create a trendline that covered only the desired range of data, rather than spanning the entire chart, without having to go in, find the data range and plot it in a chart of its own. Is there any way to do this? I'm currently using Office 2003. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
can i edit only a selected range of data in an excel chart?
Let's say the dates are in column A, the y-values in B
In column C type a 1 next to the cells you want plotted In D2 (I will assume the first row has headers) , enter =IF(D2=1,B2,NA()) Now select all the D data and copy it; click on the chart, use Edit | Paste Special to copy the data as a New Series Now format the new seresi to have the came colours etc as the original series Add a trend line to the new series You can now change the data in C to get trendlines for other regions best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "aarho" wrote in message ... I perform a lot of tests that involve changing changing an element during the run and observing the effects over time and it would be extremely useful if I could create a trendline that covered only the desired range of data, rather than spanning the entire chart, without having to go in, find the data range and plot it in a chart of its own. Is there any way to do this? I'm currently using Office 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Pie Chart Data Label | Charts and Charting in Excel | |||
Put data in range of selected cells | Excel Discussion (Misc queries) | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
Choose data from a selected range and put result in new column | Excel Worksheet Functions | |||
data validation list selected from a range | Excel Discussion (Misc queries) |