LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DavidM
 
Posts: n/a
Default Help with Charting My Data --

Hello - I have a linked Excel chart to SQL Server that runs a query
displaying various downtime information for our servers. I would like to
display a chart that shows the percentage of "Uptime" for each server per
month/year.

The percentage is calculated by the fields (TotalMinsDown /
TotalExpectedMinsUp) * 100.

I have the data presented below in Excel -- how to I chart? I can't seem to
get it to come out at all like I want it.

I would like to graph this by Month Year.

I assume I need some sort of field to create the percentage prior to
graphing.

I have my query saved within Excel and my Excel file is saved. Can I easily
re-run the query each time I want new information rather than rebuilding?

Any help would be appreciated:

DB Year ProcessMonth TotalExpectedMinsUp TotalMinsDown
SYS 2005 JAN 1320 0
SYS2 2005 JAN 1080 0
SYS3 2005 JAN 1125 0
SYS4 2005 JAN 1200 1200
SYS5 2005 JAN 1320 0
SYS6 2005 JAN 991 0
SYS7 2005 JAN 1320 0
SYS8 2005 JAN 1260 0
SYS 2004 JUL 8490 10
SYS2 2004 JUL 7860 0
SYS3 2004 JUL 8055 0
SYS4 2004 JUL 8640 8640
SYS5 2004 JUL 8220 1
SYS6 2004 JUL 7861 0
SYS7 2004 JUL 8220 0
SYS8 2004 JUL 8310 55
SYS 2004 AUG 23460 8
SYS2 2004 AUG 22020 0
SYS3 2004 AUG 22455 174
SYS4 2004 AUG 24210 24210
SYS5 2004 AUG 22920 34
SYS6 2004 AUG 21665 97
SYS7 2004 AUG 23100 109
SYS8 2004 AUG 23190 227
SYS 2004 SEP 22905 218
SYS2 2004 SEP 21480 154
SYS3 2004 SEP 21900 235
SYS4 2004 SEP 23610 23610
SYS5 2004 SEP 22320 147
SYS6 2004 SEP 21244 432
SYS7 2004 SEP 22440 167
SYS8 2004 SEP 22590 163
SYS 2004 OCT 23430 5
SYS2 2004 OCT 21780 8
SYS3 2004 OCT 22305 29
SYS4 2004 OCT 23955 19319
SYS5 2004 OCT 22890 40
SYS6 2004 OCT 21485 61
SYS7 2004 OCT 22980 17
SYS8 2004 OCT 23070 607
SYS 2004 NOV 22890 0
SYS2 2004 NOV 21480 0
SYS3 2004 NOV 21900 43
SYS4 2004 NOV 23610 19406
SYS5 2004 NOV 22260 0
SYS6 2004 NOV 21244 50
SYS7 2004 NOV 22440 31
SYS8 2004 NOV 22590 24
SYS 2004 DEC 23715 191
SYS2 2004 DEC 22260 166
SYS3 2004 DEC 22740 275
SYS4 2004 DEC 24465 20286
SYS5 2004 DEC 23130 192
SYS6 2004 DEC 22054 216
SYS7 2004 DEC 23220 39
SYS8 2004 DEC 23400 188


 
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 W/INDIRECT SERIES Ronbo Charts and Charting in Excel 3 January 3rd 05 05:17 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 02:31 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 02:47 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"