Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting: Displaying cumulative totals at top of stacked columns | Charts and Charting in Excel | |||
Charting Data over 256 Columns | Charts and Charting in Excel | |||
excel charting formulas - sum of 2 columns with differing data | Charts and Charting in Excel | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |