Hoping I can get some help on plotting a dynamic chart from a Data Table. I'm scratching my head on trying to have only every second cell plotted to create different graphs.
Here's an example of my data:[TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl63, width: 108, bgcolor: #4F81BD"]Project[/TD]
[TD="class: xl63, width: 65, bgcolor: #4F81BD"]Cost[/TD]
[TD="class: xl63, width: 65, bgcolor: #4F81BD"]Hours[/TD]
[/TR]
[TR]
[TD]Barn[/TD]
[TD="align: right"]50369[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barn Labour[/TD]
[TD="align: right"]72563[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Warehouse[/TD]
[TD="align: right"]564892[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Warehouse Labour[/TD]
[TD="align: right"]625623[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD]Restaurant[/TD]
[TD="align: right"]1536742[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Restaurant Labour[/TD]
[TD="align: right"]2659784[/TD]
[TD="align: right"]25000[/TD]
[/TR]
[TR]
[TD]Bridge[/TD]
[TD="align: right"]15065984[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bridge Labour[/TD]
[TD="align: right"]26987453[/TD]
[TD="align: right"]250000[/TD]
[/TR]
[TR]
[TD]Hangar[/TD]
[TD="align: right"]525625[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hangar Labour[/TD]
[TD="align: right"]697515[/TD]
[TD="align: right"]100000[/TD]
[/TR]
[TR]
[TD]Hospital[/TD]
[TD="align: right"]45978634[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hospital Labour[/TD]
[TD="align: right"]56597324[/TD]
[TD="align: right"]700000[/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD="align: right"]125326[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]House Labour[/TD]
[TD="align: right"]173654[/TD]
[TD="align: right"]2500[/TD]
[/TR]
</tbody>[/TABLE]
I would like to plot a few different charts from this data but not necessarily ALL of the data at once.
For example I would like to make a chart using the "Project" column names, but only every second row (the ones that exclude the word labour). Then the vertical portion of the chart may use the data from the "Cost" OR "Hours" column (for example just the numbers in the "Cost" column in light blue).
I know how to manually add the data to a chart from a regular spreadsheet but would like to use a Data Table and dynamic chart to automatically update the charts every time I enter a new project.
Any insight would be greatly appreciated!
EDIT
ugh looks like my Cut & Paste of my Data Table doesn't show the Light/Dark blue shading that Excel does sorry.
When I refer to Light Blue I'm referring to the rows of "Labour" data.
Here's an example of my data:[TABLE="width: 238"]
<tbody>[TR]
[TD="class: xl63, width: 108, bgcolor: #4F81BD"]Project[/TD]
[TD="class: xl63, width: 65, bgcolor: #4F81BD"]Cost[/TD]
[TD="class: xl63, width: 65, bgcolor: #4F81BD"]Hours[/TD]
[/TR]
[TR]
[TD]Barn[/TD]
[TD="align: right"]50369[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barn Labour[/TD]
[TD="align: right"]72563[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Warehouse[/TD]
[TD="align: right"]564892[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Warehouse Labour[/TD]
[TD="align: right"]625623[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD]Restaurant[/TD]
[TD="align: right"]1536742[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Restaurant Labour[/TD]
[TD="align: right"]2659784[/TD]
[TD="align: right"]25000[/TD]
[/TR]
[TR]
[TD]Bridge[/TD]
[TD="align: right"]15065984[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bridge Labour[/TD]
[TD="align: right"]26987453[/TD]
[TD="align: right"]250000[/TD]
[/TR]
[TR]
[TD]Hangar[/TD]
[TD="align: right"]525625[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hangar Labour[/TD]
[TD="align: right"]697515[/TD]
[TD="align: right"]100000[/TD]
[/TR]
[TR]
[TD]Hospital[/TD]
[TD="align: right"]45978634[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hospital Labour[/TD]
[TD="align: right"]56597324[/TD]
[TD="align: right"]700000[/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD="align: right"]125326[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]House Labour[/TD]
[TD="align: right"]173654[/TD]
[TD="align: right"]2500[/TD]
[/TR]
</tbody>[/TABLE]
I would like to plot a few different charts from this data but not necessarily ALL of the data at once.
For example I would like to make a chart using the "Project" column names, but only every second row (the ones that exclude the word labour). Then the vertical portion of the chart may use the data from the "Cost" OR "Hours" column (for example just the numbers in the "Cost" column in light blue).
I know how to manually add the data to a chart from a regular spreadsheet but would like to use a Data Table and dynamic chart to automatically update the charts every time I enter a new project.
Any insight would be greatly appreciated!
EDIT
ugh looks like my Cut & Paste of my Data Table doesn't show the Light/Dark blue shading that Excel does sorry.
When I refer to Light Blue I'm referring to the rows of "Labour" data.
Last edited by a moderator: