Ask Experts » Computers » Software »

How to create chart from merged cells in Excel 2007?

Date: 25 Jul 2016   Posted By: KEDAR SHIVRAM DEODHAR     Group: Computers    Category: Software   

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?

Plot line chart by using data from merged cells in excel 2007.

Author: Mahesh    27 Jul 2016      Member Level: Gold     Points : 3  (Rs 3)    Voting Score: 0

Merged cells often create conflict with the chart data. So it's beneficial you get them sorted if if you wish to show the content in chart. If the data is too large then you have to sort it for another field. Or you can write the subroutine that does the job for you. And writing such subroutine will require someone to go through your data and help you with it. You may want to ask in the official Excel forums on how to make use of VBA to display the data in merged cell for charts. Gantt charts do allow you to create such charts. However most of the time it becomes harder to use other type of charts on such data. I'd say you have to write subroutine by looking at your data for mapping the chart.

Post Answer

You must Sign In to post a response.

Post Answer        

Related Questions
  • Return to Question Index
  • Ask Question to Experts

  • Awards & Gifts
    Top Contributors
    TodayLast 7 Daysmore...

    Online Members

    ISC Technologies, Kochi - India. © All Rights Reserved.