Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHARTING W/INDIRECT SERIES | Charts and Charting in Excel | |||
Charting Data from Excel | Charts and Charting in Excel | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |