Results 1 to 3 of 3

Thread: Problem in Charting multiple values in Excel

  1. #1
    Join Date
    Dec 2008
    Posts
    12

    Problem in Charting multiple values in Excel

    Hi,
    It's a very simple problem which i am not getting through, can anyone please solve it for me. The problem is that I have a small data set of tree ages across a handful of field sites, with multiple trees aged per site. The site ID is text, e.g. ABC. What I want to do is make a chart with the site ID on the x axis and the tree ages associated with that site stacked above it.
    This has so far proven impossible. I've been trying to make a line chart (excel 2003), but what I get is the set spread out, with each data point seemingly assigned it's own unique x value and then labeled with the text. So instead of having three data points above ABC, there
    are three ABCs on the x-axis each with one point above it.

  2. #2
    Join Date
    May 2008
    Posts
    2,012

    Re: Problem in Charting multiple values in Excel

    What you can do here is associate numerical values for each category (site ID): 1 for the first, 2 for the second, and so on.

    Plot a line chart with each category appearing once and an associated value of zero. Format the line to be invisible (no line, no marker).

    Set up the rest of your data with X values corresponding to the category numbers (site ID numbers) above and Y values corresponding to tree ages. Copy this data, select the chart, use Paste Special to add this data as a new series with the appropriate settings (especially categories in first column, or row if you are so oriented). Right click on this new series, choose Chart Type, and select an XY type with markers and no lines. The XY chart will automatically plot X=1 above the first category on the line chart axis, X=2 above the second, etc.

    May solve your query ....

  3. #3
    Join Date
    Dec 2008
    Posts
    12

    Re: Problem in Charting multiple values in Excel

    Thanks a lot it did the trick for me, its really interesting the way you told me i think i should learn more about it.


Similar Threads

  1. EXCEL Lookup the same value that has multiple values
    By horse43 in forum Windows Software
    Replies: 1
    Last Post: 09-06-2012, 11:42 AM
  2. Replies: 3
    Last Post: 21-01-2012, 01:43 AM
  3. Lookup multiple values in excel
    By Alatar1313 in forum Windows Software
    Replies: 1
    Last Post: 09-12-2009, 02:49 AM
  4. Replies: 5
    Last Post: 27-10-2009, 12:40 AM
  5. Excel : vlookup multiple values
    By Laler in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 10:27 AM

Tags for this Thread

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
  •  
Page generated in 1,660,838,026.77285 seconds with 17 queries