LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 09, 01:19 PM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 57
Default Plotting Multiple Values per System in Chart


I need to chart 3 components for systems on a chart as follows:

System A
Current Capacity
Current Utilization
Planned Capacity

System B
Current Capacity
Current Utilization
Planned Capacity

And so on...

I set up a chart to display the first item over the course of 12 months, so
I have Jan - Dec on the horizontal access and the capacity unit of
measurement on the vertical. My data looks like this:

System Jan Feb Mar...
A 1000 1000 1000
B 2500 2500 2500
C 1500 1500 1500

How can I add the other components so they show up in the chart and are
labeled correctly? I would like months along the horizontal, the capacity
units along the veritical as done now. I would then like the lines on the
chart to reflect "system a current cap", "system a planned cap", and "system
a current util".

Is this possible?



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
How do I stop chart from plotting null values as zeros in excel 20 suebee Charts and Charting in Excel 3 September 5th 08 06:33 PM
OTHER options for chart not plotting null ("") or zero values superdanz Charts and Charting in Excel 2 September 2nd 08 10:00 AM
Plotting multiple data series in a bubble chart Dhananjay[_2_] Charts and Charting in Excel 1 August 22nd 07 05:57 PM
Problem with plotting a chart when using arrays as Values and Xvalues [email protected] Charts and Charting in Excel 3 August 19th 05 09:05 PM
scatter chart insists on plotting as a line chart Knows too little New Users to Excel 0 March 11th 05 07:37 PM

All times are GMT +1. The time now is 08:47 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017