Huge challenge - Dynamic chart with dynamic title based on active cell - without VBA

posted Jan 11, 2012, 8:57 AM by r   [ updated Jan 24, 2012, 3:04 PM ]
Can you do this? and how?

Only macro is:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Calculate
End Sub

but you can delete it and use F9.



News!

The winner is elby on google group microsoft.public.it.office.excel

Read the article on Excel Ticker

About the authors

Look the file!
ċ
Dynamic_chart_withdynamic_title_based_on_active_cell.xlsm
(20k)
r,
Jan 11, 2012, 8:57 AM
ċ
Dynamic_chart_withdynamic_title_based_on_active_cell_v2.xlsm
(23k)
r,
Jan 12, 2012, 7:22 AM