Hello,
i have been building a worksheet where i want user to enter start & end period for which data should be visisble on a chart.
i made two dynamic ranges one for sales data other for period using offset & match formulas.
as a second step i am changing series in a line chart with these ranges. While ranges for data is working on chart. For labels its giving an error that "formula in this worksheet contains one or more invalid references. Verify that formula contains valid path, workbook,rangename, & cell reference......"
Can you please help in solving this mystry for me
Attached is the example
Thanks
KT
Bookmarks