Forum Discussion
Solved
Inserting 2 trendlines on one chart
I have 2 sets of data, each consisting of two variables and a bunch of values under each variable (picture attached below). How can I insert two trend lines on the same chart [scatter plot] so t...
This is the data where I want a trend line only for the Commit vs Actual.
| Q1 Results | |
| Client Demand | $ 2,500,000.00 |
| Commit | $ 1,800,000.00 |
| Actual Shipped | $ 2,200,000.00 |
Giovanni1220 Not a trend line but perhaps something you can use anyway. I added another column for the red line and created a combo chart (three columns and a line). See attached.
Riny_van_Eekelen wow that's perfect. Thanks!!