View Single Post
  #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