Adding Exponential Trendline to Graphs: Struggling

Click For Summary
SUMMARY

The discussion centers on the challenges of adding an exponential trendline to graphs in Microsoft Excel. The user successfully added the trendline to one graph but faced issues with two others despite repeated attempts. Suggestions were made to consider OpenOffice or LibreOffice's Calc as viable alternatives, which offer similar functionalities and extensive documentation. The conversation highlights the ease of transitioning from Excel to these open-source tools for users who do not require specific Microsoft Office features.

PREREQUISITES
  • Familiarity with Microsoft Excel 365 graphing features
  • Basic understanding of trendlines and their applications in data analysis
  • Knowledge of OpenOffice or LibreOffice Calc functionalities
  • Experience with .xlsx file formats and data sharing
NEXT STEPS
  • Research how to add exponential trendlines in Microsoft Excel 365
  • Explore the graphing capabilities of LibreOffice Calc
  • Learn about data sharing best practices for .xlsx files
  • Investigate the differences between Microsoft Office and LibreOffice features
USEFUL FOR

This discussion is beneficial for data analysts, students, and professionals who utilize graphing tools in Microsoft Excel or are considering transitioning to open-source alternatives like LibreOffice Calc.

Eveline
Messages
1
Reaction score
0
Hi,
I need help to add an exponential trendline on my graph. I have three graphs and I have succeeded with the first one but somehow the exponential trendline will not show on the two other graphs even though I have selected the option multiple times. I also tried to re-do the graph in a new document but it did not work...
Please help me :)
 
Physics news on Phys.org
M$ Excel is a for-profit product, so that anyone that has developed expertise will expect to recoup their costs.

I suggest a Free Open Source Software alternative in OpenOffice/LibreOffice, their Calc application (VERY similar to Excel), and their extensive documentation and on-line help. Indeed, they are so similar that on-line help may suffice.

https://www.libreoffice.org/
 
Seems like a shot with closed eyes. Unless it has confidential data, you should share the .xlsx at least.

I agree, at least partially, with Doug. Based on my own experience, unless you need PowerPoint all the time (or Publisher, or OneNote, or whatever-libreoffice-does-not-offer), you could give it a try. I see a good amount of people around me making the change and liking it. Word to Writer and Excel to Calc are really easy changes.
 

Similar threads

Mathematica Mathematica 3D Graphing (3D Plot) Issue
  • · Replies 4 ·
Replies
4
Views
3K
What is the error of the trendline in Excel with error bars?
  • · Replies 2 ·
Replies
2
Views
14K
MATLAB Getting Error When Plotting Graph (Using Python w/ matplotlib.pyplot)
  • · Replies 5 ·
Replies
5
Views
3K
Graphing Data in Excel: Error Bar Confusion
  • · Replies 1 ·
Replies
1
Views
2K
Data analysis by guessing, checking and fixing
  • · Replies 5 ·
Replies
5
Views
4K
High School Kinematic equations ##\textbf{purely}## from graphs
  • · Replies 49 ·
2
Replies
49
Views
4K
MATLAB MATLAB Code For Analyzing Experimental Data
  • · Replies 12 ·
Replies
12
Views
4K
Finding the Magnetic Field (B_0) on a Graph [NMR]
  • · Replies 6 ·
Replies
6
Views
2K
Help with Creating An Excel Line Graph
  • · Replies 1 ·
Replies
1
Views
1K
Why won't Excel allow me to add an exponential trendline?
  • · Replies 16 ·
Replies
16
Views
17K