+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Forum Contributor
    Join Date
    02-11-2008
    Posts
    194

    creating chart from array of data

    I am trying to create a nice chart from the attached file but not able to do it,please advice how to do.
    Thanks
    Arnab
    Attached Files Attached Files
    Last edited by arnab0711; 11-17-2009 at 06:07 AM.

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: chart

    arnab

    please take a moment to read the forum rules and then change your thread title to something more meaningful. With your tenure you should know better!
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: creating chart from array of data

    So what information did you want your 'nice' chart to impart?
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Guru
    Join Date
    01-03-2006
    Location
    Basingstoke, England
    MS-Off Ver
    2007 (work & home)
    Posts
    2,240

    Re: creating chart from array of data

    hi Arnab,

    "A nice chart" is not very definitive. Charts are visual representations of the data which can be used to identify trends etc. To identify what chart type/layout is suitable you need to understand & to explain to us what you are attempting/need to show in your final chart. Can you please provide more detail?

    To help you get ideas of what is possible, I suggest you:
    - search for posts by "Andy Pope" in ExcelForum's forums. (Edit: when refreshing the screen after posting I see that Andy's already found the thread!)
    - have a surf through some of Jon Peltier's examples http://peltiertech.com/Excel/Charts/
    - try to create a chart & if you still can't make what you want, then add the details in a new post to this thread.

    Also, it may be wise to ask a Mod (there's a link on the Rules page) to move this thread from the "General" forum into the "Charting" forum http://www.excelforum.com/excel-charting/.

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0