Trendline Question

motorwiz

New Member
Joined
Jan 31, 2005
Messages
4
I have a scatter chart created from columns of data. Each row has a formula whose result is either a value or a blank. When I plot the data, the data points appear correctly but when I fit a trendline it skews toward the (0,0). It seems that although the scatter chart does not recognize and plot the empty cells as (0,0) the trendline does.

The Excel Help seemed to indicate one could have each cell formula display either NA or #N/A in the cells without data and thereby cause the the trendline formula to skip those cells. This did not work for me. Is there a way to leave the data in a column with discontinuous data and get the trendline to ignore the blanks?

Thanks in advance for any assistance.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
Use autofilter (highlight the data table, go to data, autofilter) to filter out data you do not want included in the graph.

If you use autofilter to filter out the 0's. They will not show up on the graph, or be included in the trendline.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,916
Messages
5,621,602
Members
415,847
Latest member
AlpinoHirsch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top