Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
SFD SFD is offline
external usenet poster
 
Posts: 2
Default Charting 3 columns help

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Charting 3 columns help

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting: Displaying cumulative totals at top of stacked columns Jean Charts and Charting in Excel 1 February 14th 06 01:30 PM
Charting Data over 256 Columns Tommy Z. Charts and Charting in Excel 1 December 2nd 05 05:26 AM
excel charting formulas - sum of 2 columns with differing data John Watson @ barkoff container Charts and Charting in Excel 2 September 19th 05 01:45 PM
charting a difference of 2 columns' w/o adding a difference column Wab Charts and Charting in Excel 4 July 27th 05 02:37 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"