Dynamic graph for 16 measures across 365 days... looks horrible. solution?

Boniouk

Board Regular
Joined
Aug 2, 2013
Messages
166
Hey,

Ihave a dashboard that looks like the image below. (the 2 false picture errors are combo boxes which are linked to A1 an A2)

The data is daily from 1st april to 31st march next year. How can i build a dynamic graph from this that doesnt look clunky and messy with all 16 measures for a full year?

Any ideas?

A
Measure1 <v:shapetype id="_x0000_t201" path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"> <o:lock shapetype="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype><v:shape style="width: 109.5pt; height: 29.25pt; margin-top: 4.5pt; margin-left: 18pt; position: absolute; z-index: 1; mso-wrap-style: tight;" id="ComboBox1" type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEADdIVzicCAADDBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWyslF1vmzAU
hu8n7T9Yvk+AQEhAJdVCm2pStUX7uK4cY4I1/CHbZamm/fcd87FG6dSLbVzZnOOX55zzmqvrk2hR
x4zlShY4mocYMUlVxeWxwF+/7GZrjKwjsiKtkqzAT8zi683bN1ckPxqiG04RKEibkwI3zuk8CCxt
mCB2rjSTEKuVEcTB1hyDypDvoCzaYBGGaSAIl3jzLHVDHEGPhv+FVKvoN1aVRHbEgmRL8/M3I2NL
/12Z5LK7M/qz3htPTj90e4N4VWDonCQCWoSDMTCmwTa4OHV8FjjVRvh8VdfoVOBFslwlS9B6gmms
w2y1HOTYySEK8SjOwtTHKSTEqyiZEmjz8XUF2ty+rgGQAwwszgA1p55PdntOL2teTDWXShzUVp2i
fpwAe2+dP+Wx+4H+SONtvN2m2WwRl7tZktzGsyzMslmZhGWa7nbrdFX+9KejJKdKaOI87uitKHkx
OMGpUVbVbg7ZAXSPUzb5C9wVhYO7kNV+OA+nEJ4HG4WLvqFQIqD1g5lg4VU/TI/tF1O1UP89mMsi
qcqGyCN7ZzWjDkbhJzOeGpJhc9amQ8v1jretF/TrsRjzopQ/XJShnhtFHwWTbrgthrXEwTW1DdcW
I5MzcWBQm3lf9Sgkt84wRxv/wRo+/AkwB8TfASA8x7Kji/+PCUF8EtLGujumBPILQASS3hmkA2MM
TFNK38MBBAR6twUX17dPGX83/h9xvt/8AgAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIAAACrAQAA
KgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoEMQyG74Lv
UHK3mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQDKBabXBBv
4PX0fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6Wzxmsm/k
GXfDcI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfdXQGva4z/
qRFij2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEA/cFa784GAAA9HAAAGgAA
AGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlPbxtFFL8j8R1Ge2/j/42jOlXs2A20aaPYLepx
vB7vTjO7s5oZJ/UNtUckJERBXJC4cUBApVbiUj5NoAiK1K/Am5nd9U68JkkbgSjNId59+5v3/715
s3v12oOIoUMiJOVxx6terniIxD6f0DjoeHdGg0vrHpIKxxPMeEw63pxI79rm++9dxRs+o8mYYzEZ
hSQiCBjFcgN3vFCpZGNtTfpAxvIyT0gMz6ZcRFjBrQjWJgIfgYCIrdUqldZahGnsbQJHpRn1GfyL
ldQEn4mhZkNQjCOQfns6pT4x2MlBVSPkXPaYQIeYdTzgOeFHI/JAeYhhqeBBx6uYP29t8+oa3kgX
MbVibWHdwPyl69IFk4OakSmCcS60Omi0r2zn/A2AqWVcv9/v9as5PwPAvg+WWl2KPBuD9Wo341kA
2ctl3r1Ks9Jw8QX+9SWd291ut9lOdbFMDcheNpbw65VWY6vm4A3I4ptL+EZ3q9drOXgDsvjWEn5w
pd1quHgDChmND5bQOqCDQco9h0w52ymFrwN8vZLCFyjIhjy7tIgpj9WqXIvwfS4GANBAhhWNkZon
ZIp9yMkejsaCYi0AbxBceGJJvlwiaVlI+oImquN9mODYK0BePf/+1fOn6NXzJ8cPnx0//On40aPj
hz9aXs7CHRwHxYUvv/3sz68/Rn88/ebl4y/K8bKI//WHT375+fNyIFTQwsIXXz757dmTF199+vt3
j0vgWwKPi/ARjYhEt8gR2ucR2GYc42pOxuJ8K0Yhps4KHALvEtZ9FTrAW3PMynBd4jrvroDmUQa8
Prvv6DoMxUzREsk3wsgB7nLOulyUOuCGllXw8GgWB+XCxayI28f4sEx2D8dOaPuzBLpmlpSO73sh
cdTcYzhWOCAxUUg/4weElFh3j1LHr7vUF1zyqUL3KOpiWuqSER07ibRYtEMjiMu8zGYIteOb3buo
y1mZ1dvk0EVCQWBWovyIMMeN1/FM4aiM5QhHrOjwm1iFZUoO58Iv4vpSQaQDwjjqT4iUZWtuC7C3
EPQbGPpVadh32TxykULRgzKeNzHnReQ2P+iFOErKsEMah0XsB/IAUhSjPa7K4LvcrRB9D3HA8cpw
36XECffpjeAODRyVFgmin8xESSyvE+7k73DOppiYLgMt3enUEY3/rm0zCn3bSnjXtjveFmxiZcWz
c6JZr8L9B1v0Np7FewSqYnmLeteh33Vo763v0Ktq+eL78qIVQ5fWA4mdtc3kHa0cvKeUsaGaM3JT
mtlbwgY0GQBRrzMHTJIfxJIQLnUlgwAHFwhs1iDB1UdUhcMQJzC3Vz3NJJAp60CihEs4LxpyKW+N
h9lf2dNmU59DbOeQWO3yiSXXNTk7buRsjFaBOdNmguqawVmF1a+kTMG21xFW1UqdWVrVqGaaoiMt
N1m72JzLweW5aUDMvQmTDYJ5CLzcgiO+Fg3nHczIRPvdxigLi4nCRYZIhnhC0hhpu5djVDVBynJl
yRBth00GfXY8xWsFaW3N9g2knSVIRXGNFeKy6L1JlLIMXkQJuJ0sRxYXi5PF6KjjtZu1pod8nHS8
KRyV4TJKIOpSD5OYBfCSyVfCpv2pxWyqfBHNdmaYWwRVePth/b5ksNMHEiHVNpahTQ3zKE0BFmtJ
Vv9aE9x6UQaUdKOzaVFfh2T417QAP7qhJdMp8VUx2AWK9p29TVspnykihuHkCI3ZTOxjCL9OVbBn
QiW88TAdQd/A6zntbfPIbc5p0RVfihmcpWOWhDhtt7pEs0q2cNOQch3MXUE9sK1Ud2Pc+U0xJX9B
phTT+H9mit5P4BVEfaIj4MO7XoGRrpSOx4UKOXShJKT+QMDgYHoHZAu84oXHkFTwYtr8CnKof23N
WR6mrOEkqfZpgASF/UiFgpA9aEsm+05hVk33LsuSpYxMRhXUlYlVe0wOCRvpHtjSe7uHQkh1003S
NmBwJ/PPvU8raBzoIadYb04ny/deWwP/9ORjixmMcvuwGWgy/+cq5uPBYle1683ybO8tGqIfLMas
RlYVIKywFbTTsn9NFc651dqOtWRxrZkpB1FcthiI+UCUwIskpP/B/keFz+xHDL2hjvg+9FYE3y80
M0gbyOpLdvBAukFa4hgGJ0u0yaRZWdemo5P2WrZZX/Ckm8s94Wyt2VnifU5n58OZK86pxYt0duph
x9eWttLVENmTJQqkaXaQMYEp+5i1ixM0DqodDz4oQaAfwBV8kvKAVtO0mqbBFXxngmHJfhzqeOlF
RoHnlpJj6hmlnmEaGaWRUZoZBYaz9DNMRmlBp9JfTuDLnf7xUPaRBCa49KNK1lSdL36bfwEAAP//
AwBQSwMECgAAAAAAAAAhAPSPF1LhAgAA4QIAABoAAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBu
Z4lQTkcNChoKAAAADUlIRFIAAADlAAAAPggGAAAA1DDc+gAAAAFzUkdCAK7OHOkAAAAEZ0FNQQAA
sY8L/GEFAAAACXBIWXMAABcRAAAXEQHKJvM/AAACdklEQVR4Xu3c0Y2iUBSAYeuiIBO7sQSrsBkf
bcAO2EW9ibqHBdyFewa+LznJxGEm88CfK1yc3el0ao0xdafYdaIDjDHLTvEW5eFwMMZUmOv1+kwy
iBJ46EKZe0QJE3wGNMeIEiYo4cylNCdKGOk1ytvt9t9HlDCRKCEZUUIyooRkRAnJiBKSESUkI0pI
RpSQjCghGVFCMqKEZDYb5eXYdH9EME17vDwPggq2GeXl2DZhkI/Zn5/HQQWbjPK8j2Ms01gqqWh7
UQ6skvexVFLRxqK8tMcmiPBzmuPvI6GObUV53gcBNsHKuW+tldSyoSijVbK703pu92+vldefPwYL
206U0Sp5v3aM39K6rKSWjUTZt0o+vhvdjRUltWwiyvBBgZfqoihti1DLUJSf5+rfJvr5BFEOXzMO
RQtLWn2Uo4IL78raFqGOoSjL/HHOvkx0fJnKUY68sxo+UGBbhDrGRtnN+zn7mOi416kaZbhKRitg
GKVtEepYb5Q9j9PFl4rRiuoOLHVMibJMd75Gr0dTLcrwofPe60R7leTxTZRTpk6Uk1bJB9siZLHK
KIc+mjV6LJVUsL4ox3w0a+zYFqGClUU58qNZo8e2CMtbV5TRQwD/NLZFWN6KouxZJce+Bf3i5hDM
YT1RhqvklJUu3qt0B5alrSTKnlVy0jIX/w5RsrRVRBn/D9fp14PhVor3ryxsBVHGbzu/iWn0s7Iw
o58fZXiD5rutDFGSwc+PElZGlJCMKCEZUUIyooRkRAnJiBKSESUkI0pIRpSQTImy9DHHiBImKMEs
MaKEET7DmXN6oyzLtTFm+SnuUT6/BhIQJSRzjxLIZLf7BeSUd9pkBSqlAAAAAElFTkSuQmCCUEsB
Ai0AFAAGAAgAAAAhADQS/3gUAQAAUAIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVz
XS54bWxQSwECLQAUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAAAAAAAAAAAAAABFAQAAX3JlbHMv
LnJlbHNQSwECLQAUAAYACAAAACEADdIVzicCAADDBAAAHwAAAAAAAAAAAAAAAAAvAgAAY2xpcGJv
YXJkL2RyYXdpbmdzL2RyYXdpbmcxLnhtbFBLAQItABQABgAIAAAAIQBTUolh0gAAAKsBAAAqAAAA
AAAAAAAAAAAAAJMEAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHNQ
SwECLQAUAAYACAAAACEA/cFa784GAAA9HAAAGgAAAAAAAAAAAAAAAACtBQAAY2xpcGJvYXJkL3Ro
ZW1lL3RoZW1lMS54bWxQSwECLQAKAAAAAAAAACEA9I8XUuECAADhAgAAGgAAAAAAAAAAAAAAAACz
DAAAY2xpcGJvYXJkL21lZGlhL2ltYWdlMS5wbmdQSwUGAAAAAAYABgCvAQAAzA8AAAAA
" o:spid="_x0000_s1025"> <v:imagedata o:title="" src="file:///C:\Users\601840~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:autoline>False</x:autoline> <x:fmlalink>$A$16777217</x:fmlalink> <x:cf>Pict</x:cf> <x:autopict> <x:mapocx> </x:mapocx></x:autopict></x:sizewithcells></x:clientdata> </v:imagedata></v:shape>
<tbody> </tbody>
<v:shape style="width: 138pt; height: 29.25pt; margin-top: 0.75pt; margin-left: 3.75pt; position: absolute; z-index: 2; mso-wrap-style: tight;" id="ComboBox2" type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAZEbpiCgCAADDBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWyslMlu2zAQ
hu8F+g4E77YWy3IsRA5qJQ4KBK3R5RzQFGURFReQjKqg6Lt3qKU2nCKHtrqIFIc/v39mqOubTjSo
ZcZyJXMczUOMmKSq5PKY469fdrMrjKwjsiSNkizHz8zim83bN9ckOxqia04RKEibkRzXzuksCCyt
mSB2rjSTsFYpI4iDqTkGpSHfQVk0QRyGaSAIl3hzkroljqAnw/9CqlH0GysLIltiQbKh2fmXkbGh
/65MMtneG/1Z740npx/avUG8zDFkThIBKcLBuDCGwTS42HU8CXSVET5eVRXqchzHqzRZLTF6znEa
raN4OcixziEK69FqGachnEUhYLGKfOxwXv3xdQVa372uAZADDAzOADWnnk+2e04vPceT50KJg9qq
Lu7LCbAP1vldHrsv6I90sV1st+l6Fi+K3SxJ7hazdbhez4okLNJ0t7tKV8VPvztKMqqEJs7jjr0V
JS8KJzg1yqrKzSE6gOxxyqb+gu6KwqG7kNW+OI9dCM+jjcI49fkCi4A2vXtY+NQX02P7weQW/D9A
c1kkVVETeWTvrGbUQSlGoVMwSJyl6dBwveNN4wX9eDRjXlj5w0UZ/Nwq+iSYdMNtMawhDq6prbm2
GJmMiQMDb+Z92aOQzDrDHK39gRUc/AkwB6+/F4DwHMuOXfx/mhDEJyFtrLtnSiA/AEQg6TuDtJDr
gWkK6YswgIBA323BxfXtQ8bfjf9HnM83vwAAAP//AwBQSwMEFAAGAAgAAAAhAFNSiWHSAAAAqwEA
ACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHOskMFKBDEMhu+C
71Byt5nZg4hsZy8i7FXWBwhtplOcpqWt4r691b04sODFSyAJ+fLx7w+fcVUfXGpIYmDUAygWm1wQ
b+D19Hz3AKo2EkdrEjZw5gqH6fZm/8IrtX5Ul5Cr6hSpBpbW8iNitQtHqjpllr6ZU4nUels8ZrJv
5Bl3w3CP5TcDpg1THZ2BcnQ7UKdz7p//Zqd5Dpafkn2PLO3KC2zdizuQiudmQOvL5FJH3V0Br2uM
/6kRYo9goxHZBcKf+aiz+G8N3EQ8fQEAAP//AwBQSwMEFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoA
AABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3q
cbwe704zu7OaGSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVOvCZJG4EozSHeffub9/+9
ebN79dqDiKFDIiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6cSO/a5vvvXcUbPqPJmGMx
GYUkIggYxXIDd7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3VKpXWWoRp7G0CR6UZ9Rn8
i5XUBJ+JoWZDUIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmIYangQcermD9vbfPqGt5I
FzG1Ym1h3cD8pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8DwL4Pllpdijwbg/VqN+NZ
ANnLZd69SrPScPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKbS/hGd6vXazl4A7L41hJ+
cKXdarh4AwoZjQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/VqlyL8H0uBgDQQIYVjZGa
J2SKfcjJHo7GgmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXzp+jV8yfHD58dP/zp+NGj
44c/Wl7Owh0cB8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU0MLCF18++e3Zkxdfffr7
d49L4FsCj4vwEY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6wFtzzMpwXeI6766A5lEG
vD677+g6DMVM0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBMdg/HTmj7swS6ZpaUju97
IXHU3GM4VjggMVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0WLRDI4jLvMxmCLXjm927
qMtZmdXb5NBFQkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6UkGkA8I46k+IlGVrbguw
txD0Gxj6VWnYd9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIUoz2uyuC73K0QfQ9xwPHK
cN+lxAn36Y3gDg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65tMwp920p417Y73hZsYmXF
s3OiWa/C/Qdb9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJnbXN5B2tHLynlLGhmjNy
U5rZW8IGNBkAUa8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9zSSQKetAooRLOC8acilv
jYfZX9nTZlOfQ2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzBttcRVtVKnVla1ahmmqIj
LTdZu9icy8HluWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWGSIZ4QtIYabuXY1Q1Qcpy
ZckQbYdNBn12PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcWF4uTxeio47WbtaaHfJx0
vCkcleEySiDqUg+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDTBxIh1TaWoU0N8yhNARZr
SVb/WhPcelEGlHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8pIobh5AiN2UzsYwi/TlWw
Z0IlvPEwHUHfwOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHIdzF1BPbCtVHdj3PlNMSV/
QaYU0/h/ZoreT+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QLvOKFx5BU8GLa/ApyqH9t
zVkepqzhJKn2aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtMDgkb6R7Y0nu7h0JIddNN
0jZgcCfzz71PK2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubjwWJXtevN8mzvLRqiHyzG
rEZWFSCssBW007J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5Hhc/sRwy9oY74PvRWBN8v
NDNIG8jqS3bwQLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ4n1OZ+fDmSvOqcWLdHbq
YcfXlrbS1RDZkyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbTtJqmwRV8Z4JhyX4c6njp
RUaB55aSY+oZpZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQmuPSjStZUnS9+m38BAAD/
/wMAUEsDBAoAAAAAAAAAIQBNx5Xf5AYAAOQGAAAaAAAAY2xpcGJvYXJkL21lZGlhL2ltYWdlMS5w
bmeJUE5HDQoaCgAAAA1JSERSAAABIQAAAD4IBgAAAGTqreEAAAABc1JHQgCuzhzpAAAABGdBTUEA
ALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAABnlJREFUeF7tnOtt4zAQhF2XCjKQblxCqnAz
+ZkG0oFPksWYImeXu7IY4sj5gAEOF4bP3eFSB9zl8/PzQVEU9ZcKXBZQA4qiqJoK7Ezo4+ODoiiq
ur6/vzcLAiZECBmTxRhqiyZECBFJDaOGaEKEEJFgFLUIHkMTIoRAYhP6+fk5XTQhQogKTYgQ0hSa
ECGkKTQhQkhTaEKEkKbQhAghTaEJEUKaQhMihDSFJkQIaQpNiBDSFJoQIaQpNCFCSFPGMKGv22O6
XJZBfzXdvrYfvsfXbdr1e2bfpBNA/F3v289I/yZ0v+4PP9VRwyj1e5luD1rR6Hw9bhOIjVk0oRd9
mxC4gXJdH954QNVPJprQ0OiX1PRgsfyibxO6X5PDR/IGxP1xhf0k4lU3JqaY8198PdO1CZkqllke
vyg+wzbRg0bDeDktYpW8o2sTQoZxveY3lfm7EHreTdfHNXv3s9weDeuFt4o31I6OTQjdTLM53IGR
mIICfWQU+mO5PRggNtZqB1dH9KA9/ZoQ/Ci9mAMIDEt5jN76SzShv7eW24UP5/5/uZOfBHHgpxWi
mhSlj/vaL4O9Uceytk/nFDXKK5LChXDKGUQmFE8Y9s0qOaVfExLNAVU0pcpFqILmYIJluJppM6XE
3skWtKZvVcu8wNh4umjNggTThc9hcWvweKh91u/aSJqvcLYVziADxSCr5IxuTQiZQ7jV8uTQg8zX
l37bu74d/Eqbn8MsZk1TOj7q2/GRdRE0IeE5LK7D2j5f73S7y3sA5nb+GWDgONYqeSBKJpTtoSL0
+81MSDMHFByycaDkCLcZMgAlWOHNaJQwQbROn/KbWe5zWRvYDzQ3WGkoVYC5fT5+bqzRz9LDqHAG
GOFycPUxBp2akH6rapVNilrpeBJNKP/RuOYbVEmoV6wXKqW0X5d5LH0Lpis+hwVQe7O5SUrmVuMM
RFAM6lXyqJRMKCjdy1iofVAbEyol0jsBHweiOdGwEUjGVxx3RTIXbBgwqWZZKgVxngpwPCUDkdmb
zSFINYkaZ6AAY1CpkgfGakKL9vv5FGoXq40JlczhjSSP88icaGazemLqF/U5S8lzmOhpe695SFhN
5Ul5rwPiU7FkEDXOQAOej1RRjk2XJoQCaJ8A2neeDRRESRBaknrBnpBSdZP3C5NRTRL9iRqAybfK
k0C2sV5Y2/uqv5gaZ6AB97FklIPiMaGgZT/R3yM1MaGyOaBAi4PekhSlPgKoL6ey6Md9qkkCnwcg
eWG7WAYzso4VMLfH65YrrECNM9AQjMzVxzgcMSGPGpiQxUDmVopRmUpxa+IIzyarYIIdKfUdzxFY
ZaXSEsox1oqh6lzxmlugxhmoHLgkBqY/EzIGqvhke8dcQKLJzxtdWuAfKfXtz5En7xiRycQjrHPz
9huocQYqMIZQlUwW+jOhd8xhDuizE8Kb/BagQajJePRmlr+PBKE+XGuGCXtCvxE1zkAFVl6Gim1Q
ujMhZA4w4MwlOg4eFNh54uAkLie/jteEcCXguZllM8r31vYcDsC1wPZH97LOGWjA/S5UqiPTnQnZ
zGFGuIFT4WBFgX1m4ui4TEhcp/dmxmt5y4TEiwDNzWduL/7ahPB4eqU6Np2ZkCdQ8RNlJ+n2sn43
MieuD7sJKWs8cDOjcbO1WL+HaJcAWot5z1PqnIEM3nN6kExfJuQKVOHGiiQGjvG70wJ+bhiSZxlD
6BM/r5L5Fp6bWRKu7bV5GQ1eMJd4PGn+Qcgg4O8YM7vGGYhYTZj80pcJOcxhAQfnJiXAXQmhmUE8
N8/ctT6NSqe734t90oimgeanVThI05S1R1tpqsIkapwBNGWPLFXcGHRlQihZtECVb2T95kIJIXtW
ueISJXbqSYB5Lbc0udL1HZmjtEeevuY+sv+ZEvWL+5T3PKXCGbx9EdCEAl2ZkM8cZqRAUn8JBbSU
kBve6mDTobnv9JxXbrZpAnhvdX29srnH2vrI1oGS0/gU1Dj5DGxrVKQe7lh0ZEJnmUPphkIJYbnV
nBWCJcE0I4qCPDNnmAC2+VmfQGqSRuNn7dDc0DmJzySN887gXROiB73oyIQIIf8jNCFCSFNoQoSQ
ptCECCFNoQkRQppCEyKENIUmRAhpCk2IENIUmhAhpCk0IUJIU4IJBT+oIZoQIUQkGMRfiCZECMlI
jaKmRBMK5RhFUVRtBVYT2v5MCCF/Dk2IENKU1YQIIaQdl8s/ttqv4fBooDgAAAAASUVORK5CYIJQ
SwECLQAUAAYACAAAACEANBL/eBQBAABQAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlw
ZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAAEUBAABfcmVs
cy8ucmVsc1BLAQItABQABgAIAAAAIQBkRumIKAIAAMMEAAAfAAAAAAAAAAAAAAAAAC8CAABjbGlw
Ym9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAFNSiWHSAAAAqwEAACoA
AAAAAAAAAAAAAAAAlAQAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVs
c1BLAQItABQABgAIAAAAIQD9wVrvzgYAAD0cAAAaAAAAAAAAAAAAAAAAAK4FAABjbGlwYm9hcmQv
dGhlbWUvdGhlbWUxLnhtbFBLAQItAAoAAAAAAAAAIQBNx5Xf5AYAAOQGAAAaAAAAAAAAAAAAAAAA
ALQMAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ1BLBQYAAAAABgAGAK8BAADQEwAAAAA=
" o:spid="_x0000_s1026"> <v:imagedata o:title="" src="file:///C:\Users\601840~1\AppData\Local\Temp\msohtmlclip1\01\clip_image003.emz"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:autoline>False</x:autoline> <x:fmlalink>$A$16777218</x:fmlalink> <x:cf>Pict</x:cf> <x:autopict> <x:mapocx> </x:mapocx></x:autopict></x:sizewithcells></x:clientdata> </v:imagedata></v:shape>
<tbody> </tbody>
11
DateMeasure1 Mon 01 AprTue 02 Apr
AMeasure1 Manager 1A00
A1Measure1 Manager 2A100
A2Measure1 Manager 3A200
A11Measure1 Manager 4A1100
A12Measure1 Manager 5A1200
A13Measure1 Manager 6A1300
A14Measure1 Manager 7A1400
A15Measure1 Manager 8A1500
A21Measure1 Manager 10A2100
A22Measure1 Manager 11A2200
A23Measure1 Manager 12A2300
A24Measure1 Manager 13A2400
A25Measure1 Manager 14A2500
A26Measure1 Manager 15A2600
A27Measure1 Manager 16A2700

<colgroup><col style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;" width="123"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" width="111"> <col style="width: 101pt; mso-width-source: userset; mso-width-alt: 4900;" width="134"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;" width="59"> <col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <tbody>
</tbody>
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,215,261
Messages
6,123,931
Members
449,134
Latest member
NickWBA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top