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.
Bookmarks