Hi Guys
I was wondering if any of you experts could tell me how to create a slider scale type bar chart if at all possible.
I'm due to produce my monthly energy reports at work and want to make them look a little swankier by updating and refreshing the overall format a little. A portion of my energy report consists of a breakdown of sub-electric meters and sub gas-meter (please see the brief example in the table below). You'll see from the example below the data I normally present comprises each sub-meters actual consumption, the target we set for that sub meter and the variance between the two. I usually use a simple overlapped bar chart for each sub-meter which shows target and consumption. But I want to change this to a performance type slider scale if at all possible (imagine the standard traffic light conditional formatting feature but as a slider scale).
E.g. of data and a rather cruddy diagram of what I'm after, (I do have a picture of the type of thing I am after and would post it but am quite restricted with the internet and such related stuff at work).</SPAN>
<TBODY>
</TBODY>
NB/FYI: This is actual data ripped from our metering AMR software from the previous week (the data is in kilo watt hours (kWh)), the sub-meter names are labeled as such in this example for illustrative purposes only. God forbid that a TV would consume 7,904 kWh in a week! Also my cruddy slider bar diagrams are non-representative and estimations only of the data.</SPAN>
So anyway, apologies for the essay, can anybody help with this query?
Thanks,
Ethan</SPAN></SPAN>
I was wondering if any of you experts could tell me how to create a slider scale type bar chart if at all possible.
I'm due to produce my monthly energy reports at work and want to make them look a little swankier by updating and refreshing the overall format a little. A portion of my energy report consists of a breakdown of sub-electric meters and sub gas-meter (please see the brief example in the table below). You'll see from the example below the data I normally present comprises each sub-meters actual consumption, the target we set for that sub meter and the variance between the two. I usually use a simple overlapped bar chart for each sub-meter which shows target and consumption. But I want to change this to a performance type slider scale if at all possible (imagine the standard traffic light conditional formatting feature but as a slider scale).
E.g. of data and a rather cruddy diagram of what I'm after, (I do have a picture of the type of thing I am after and would post it but am quite restricted with the internet and such related stuff at work).</SPAN>
Sub Meter Name</SPAN> | Consumption</SPAN> | Target</SPAN> | Variance</SPAN> | Performance/slider scale</SPAN> |
Washing Machine (elec)</SPAN> | 7,985</SPAN> | 8,867</SPAN> | -882</SPAN> | |||||||||||||||</SPAN>|||||||||||||||||||</SPAN> |
Television (elec)</SPAN> | 7,904</SPAN> | 7,636</SPAN> | 268</SPAN> | |||||||||||||||</SPAN>|||||||||||||||||||</SPAN> |
Computer (elec)</SPAN> | 3,121</SPAN> | 3,315</SPAN> | -194</SPAN> | |||||||||||||||</SPAN>|||||||||||||||||||</SPAN> |
Cooker (gas)</SPAN> | 23,109</SPAN> | 21,843</SPAN> | 1,266</SPAN> | </SPAN></SPAN></SPAN>|||||||||||||||</SPAN>||||||||||||||||||| |
<TBODY>
</TBODY>
NB/FYI: This is actual data ripped from our metering AMR software from the previous week (the data is in kilo watt hours (kWh)), the sub-meter names are labeled as such in this example for illustrative purposes only. God forbid that a TV would consume 7,904 kWh in a week! Also my cruddy slider bar diagrams are non-representative and estimations only of the data.</SPAN>
So anyway, apologies for the essay, can anybody help with this query?
Thanks,
Ethan</SPAN></SPAN>