+ Reply to Thread
Results 1 to 1 of 1

dynamic graph

  1. #1
    Forum Contributor
    Join Date
    07-08-2010
    Location
    ireland
    MS-Off Ver
    Excel 2007
    Posts
    121

    dynamic graph

    Hello,
    I have created user defined and current pick up value where user can pick any option to see the trend. I have two worksheet, one is where user give his comments and add data, 2nd wiill be my data table for graph to pick up value. As my data will linked with another worksheet, so the values appears in the data will be 0 for further month of the year. which On the graph is quite distracting for user. For example the user wants oct 2006 to oct 2008, as the value linked with another sheet, so the value appears on data table will be 0, the graph atutomatically pick cell values, so can this not appears on graph (see attached file please).
    Any suggestion?
    another thing, i have noticed that defined data range picking extra cell as you can see in the attached file

    regards
    shahid
    Attached Files Attached Files
    Last edited by shido; 11-30-2010 at 07:31 AM.

+ Reply to Thread

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.6.0 RC 1