How to create chart from merged cells in Excel 2007?
Plot line chart by using data from merged cells in excel 2007.
I have data in merged cells of Excel 2007. I want to plot line chart by using this data. I do not want to take this data in another cells by giving cell reference (for creating chart). Because this is time consuming for large amount of data. So please tell me how can I create line chart from merged cells data?