linking a shape with values on a chart

skf786

Board Regular
Joined
Sep 26, 2010
Messages
104
Hi,

i have two breakeven charts on a sheet one above the other. Both have number of months on X Axis. these are line charts of 1) revenue and expenses and 2) profit and show the breakeven point. These are dynamic charts and BE points change as the user changes variables in the excel file. BE point on both chart always remain identical.

I would like to draw a dotted line from BE in one chart to the BE in the other chart. And the line will shift as the BE changes due to new input by the user.

Any way of doing this?

Thank you
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

mamady

Board Regular
Joined
Sep 23, 2011
Messages
163
Office Version
  1. 365
Platform
  1. Windows
I think this is possible by adding an additional data point for the chart where it dynamically seeks the EQ point (by formula), and by using combo chart you can give it Bar type and format it to be dotted.

I hope my suggestion makes sense
 

skf786

Board Regular
Joined
Sep 26, 2010
Messages
104
I think this is possible by adding an additional data point for the chart where it dynamically seeks the EQ point (by formula), and by using combo chart you can give it Bar type and format it to be dotted.

I hope my suggestion makes sense
Great idea. it works great for a single chart. However, i have two separate charts so what i did was to improvise based on your suggestion and add a third big chart behind the first two. The third one has the same scale on X axis as the other two with a big 100% bar. this bar is linked with the break even points in the other two and therefore look to be right behind the relevant points on the main two charts.

thanks for the idea!
 

mamady

Board Regular
Joined
Sep 23, 2011
Messages
163
Office Version
  1. 365
Platform
  1. Windows
I'm glad :)

Good luck
 

Watch MrExcel Video

Forum statistics

Threads
1,118,414
Messages
5,571,970
Members
412,429
Latest member
brahmaiah
Top