In your brief sample, Incident has no variation. How do you want staffing to
appear in the chart?
To make a chart more easily, put the X values in the first column and the Y
values in subsequent columns. Unless it's an XY chart, delete the contents
of the cell atop the X column, which will help Excel parse the range into X
and Y values. Then create your chart. I'd suggest that you first try a line
chart, with Staffing and Time as two series plotted against Incident.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"SFD" wrote in message
...
I am working on a staffing chart with three columns:
Staffing Time Incident
6 3 1234
15 9 1234
I would like a graph to show
the "Time" on the left
the "Incident" on the bottom
and Staffing in the chart
I have racked my brain and have not figured out how, to make the chart
work
that is :o)
Do I need to re-arrange the columns? a different way?
Any help would be greatly appreciated.
Steve