Excel 2007 - How to add MidPoint over Clustered Clolumn Chart

[Zuhair Fardan]

Dears

Anyone could you please help me over the follwoing function in Exce 2007?

I need to add 'Midpoint' over the clustered column chart.

Thank you indeed for your respons.

Mr. Zuhair Fardan

 

[Gerald Higgins]

Hi, welcome to the board.

What do you define as the midpoint ?

 

[Zuhair Fardan]

I have the follwoing data:

Values
1. Receipts
2. Payments

Periods:
2006
2007
2008
2009
2010

I made a clustered column for the above data and it looks perfect & understandable.

But, I want to show the interaction (throughout the periods) between the receipts & payments over the clustered column (i.e. lines).

I am not sure if my understanding logic is correct or not.

Thanks for your help & response.

 

[Gerald Higgins]

Sorry, I don't understand what you mean.

How about showing us the actual values (make them up if you want to keep them private), along with whatever you think the intersaction is.

 

[Jon Peltier]

Would a line chart show what you need better than a column chart?

(I think we're all confused by your term "midpoint").