I will send you the Excel file I created via private message. The blue and gray maps do not show the Exponential trendline because the y-axis is empty and has no value. Q & WE Stats Sheet and pasted it to the new Excel file, then I inserted the chart according to the chart in your file. I created a new Excel file, then I copied the content ofĬont. I have tested it again according to the file you provided, as results shown below: * Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here. * Beware of scammers posting fake support numbers here. If you want to present Exponential trendline, please make sure your data doesn’t As shown below:įor more details, you can refer to this article: Add a trendįor other scatter plots where the y-axis doesn’t include zero, Exponential trendline can be displayed. An exponential trendline is not available when your data includes negative or zero values. > selected Exponential in Trendline and it can show normally, as shown below:Īt the same time, I noticed that there are two sets of data graphs that cannot display Exponential trendline, this may be because your y-axis data is 0.
#TRENDLINE IN SCATTER CHART EXCEL SERIES#
I selected the first chart > then I clicked Chart Design > clicked Select Data > click Add and edit the data range of Series X values and Series Y values, as shown below: Thank you for the Excel file you provided in private message. Sukie - * Beware of scammers posting fake support numbers here. Please click on the link below to access your private message: If it only occurs in a specific file, I want to collect the problematic excel file with you via private message.
#TRENDLINE IN SCATTER CHART EXCEL HOW TO#
This guide will show you how to connect these data points. When the scatter plot (or line plot) is created based on the data there are large gaps in the data lines. The example below shows two batches with sporadic weekly measurements. This guide will demonstrate how to change a line or scatter chart with missing data lines due to non data or blank cells into a connected line or scatter chart. In most case the second option, with the connecting line, is the most useful. There is no connecting line between the data points and the point can appear as a single entry.īy default excel performs the third option and does not connect the scatter plot data points.A connecting line is draw between the available data points which spans missing cell entries.The blank cell is given a value of zero.Excel can manage missing data or bank cells when creating scatter or line charts in three different ways: Microsoft excel does not automatically connect data points in scatter or line charts when there is missing data or empty cells (see excel example below).