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...
Riny_van_Eekelen Hello, hoping you can help me.
I am trying to create a bar graph chart for our quarterly sales results. I am comparing our client's demand to our commitment vs what we actually shipped. I have the bars properly displayed but I am trying to show the trend from our commit vs the actual on the same chart. Basically, I have 3 bars, the client (ex 2,5M), commit (ex 1.8M), and actual (ex 2.2M). I want to display the trendline only from the commit to the actual (ex displaying better results than our commit). All I am able to do is show the trend of all the totals or have 2 separate charts. Appreciate your help.
Giovanni1220 Difficult to visualize what you are trying to achieve. Can you share a file (Onedrive or similar) with some example data and the graph that you have already made?
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!!
