Proposed change to trend line

BillBeatty

New Member
Joined
Oct 14, 2018
Messages
1
Hi all, first time poster - long time reader.

I am trying to put together a report that shows a bunch of graphs which display the impact of a proposed transaction.

i.e. Sales trend - showing the past 12 months (including current month) of sales for "Customer A" on a simple line graph and placing a trend line on it. <- that's the easy part.

But on that, displaying a hypothetical or proposed change. i.e. sales this month are sitting at $10,000 (which the line graph will show) but if this proposed 'deal' goes ahead which has a value of $2,000 the months sales would be $12,000. So i would like to show the ACTUAL line and also the PROPOSED line so the impact of the change is displayed. Also, i'd like this to show on both the line graph AND the trend line to show if this is going to have a positive or negative affect to average monthly sales. I've managed to come up with a work around for the first part and add a second axis to the line graph (maybe not the best way?) but can't work out how to show this on the trend line..

This is just an example.. i'll be using the same logic over different graphs which show average gross profit percentage and number of other metrics..

Hopefully that all makes sense!

TIA
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,144,698
Messages
5,725,822
Members
422,643
Latest member
elwayfan446

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