+ Reply to Thread
Results 1 to 2 of 2

Unable to Plot Values on Chart

  1. #1
    elusiverunner
    Guest

    Unable to Plot Values on Chart

    I am trying to plot two values for each day on a line chart. I have followed
    procedures that I have used in other line charts that is clicking on the
    range of values I want, but all I get is the two axis not values - could
    someone help me out on this one ??
    --
    Steven.

    In God we trust, all others we virus scan.

  2. #2
    Tushar Mehta
    Guest

    Re: Unable to Plot Values on Chart

    It is possible that the columns are formatted as text (or the data were
    somehow entered as text). Select the entire column and then Format |
    Cells... | Number tab. Ensure you have 'General' selected. Next, copy
    any empty cell. Now, select the cells containing the data you want to
    plot. Then, do Edit | Paste Special... | In the Operation section
    select Add the click OK. Now, try creating the chart again.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > I am trying to plot two values for each day on a line chart. I have followed
    > procedures that I have used in other line charts that is clicking on the
    > range of values I want, but all I get is the two axis not values - could
    > someone help me out on this one ??
    >


+ 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