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>
[TABLE="width: 627"]
<TBODY>[TR]
[TD]Sub Meter Name</SPAN>
[/TD]
[TD]Consumption</SPAN>
[/TD]
[TD]Target</SPAN>
[/TD]
[TD]Variance</SPAN>
[/TD]
[TD]Performance/slider scale</SPAN>
[/TD]
[/TR]
[TR]
[TD]Washing Machine (elec)</SPAN>
[/TD]
[TD]7,985</SPAN>
[/TD]
[TD]8,867</SPAN>
[/TD]
[TD]-882</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Television (elec)</SPAN>
[/TD]
[TD]7,904</SPAN>
[/TD]
[TD]7,636</SPAN>
[/TD]
[TD]268</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Computer (elec)</SPAN>
[/TD]
[TD]3,121</SPAN>
[/TD]
[TD]3,315</SPAN>
[/TD]
[TD]-194</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Cooker (gas)</SPAN>
[/TD]
[TD]23,109</SPAN>
[/TD]
[TD]21,843</SPAN>
[/TD]
[TD]1,266</SPAN>
[/TD]
[TD]</SPAN></SPAN></SPAN>|||||||||||||||</SPAN>|||||||||||||||||||
[/TD]
[/TR]
</TBODY>[/TABLE]
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>
[TABLE="width: 627"]
<TBODY>[TR]
[TD]Sub Meter Name</SPAN>
[/TD]
[TD]Consumption</SPAN>
[/TD]
[TD]Target</SPAN>
[/TD]
[TD]Variance</SPAN>
[/TD]
[TD]Performance/slider scale</SPAN>
[/TD]
[/TR]
[TR]
[TD]Washing Machine (elec)</SPAN>
[/TD]
[TD]7,985</SPAN>
[/TD]
[TD]8,867</SPAN>
[/TD]
[TD]-882</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Television (elec)</SPAN>
[/TD]
[TD]7,904</SPAN>
[/TD]
[TD]7,636</SPAN>
[/TD]
[TD]268</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Computer (elec)</SPAN>
[/TD]
[TD]3,121</SPAN>
[/TD]
[TD]3,315</SPAN>
[/TD]
[TD]-194</SPAN>
[/TD]
[TD]|||||||||||||||</SPAN>|||||||||||||||||||</SPAN>
[/TD]
[/TR]
[TR]
[TD]Cooker (gas)</SPAN>
[/TD]
[TD]23,109</SPAN>
[/TD]
[TD]21,843</SPAN>
[/TD]
[TD]1,266</SPAN>
[/TD]
[TD]</SPAN></SPAN></SPAN>|||||||||||||||</SPAN>|||||||||||||||||||
[/TD]
[/TR]
</TBODY>[/TABLE]
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>
