Plot every second cell in a dynamic chart

bernie132

New Member
Joined
Jul 28, 2018
Messages
1
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!:confused:

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:

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,224,825
Messages
6,181,191
Members
453,021
Latest member
pingpong7117

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