Thread: Chart source data puzzle

What I have: I inherited a chart and table that I am required to use. The chart is supposed to display table values and percentage. As the table and chart is now, values have to be manually entered into the table then the chart with each new use. Table data isn't linked to the chart. I tried to figure out how the percentages are calculated without success.
What I need: I would like to enter Occupied hours in the table and display those hours and the unoccupied hours in the chart with the percentage each value is of 168 hours.

All you need to do is change the input of the data into the chart. To do this, right click on the chart and hit Select Data. From there, select the only range of values that you are plotting and replace it with the two cells that have the values in it. Here's what the finished product should look like.

Thanks. I tried your rework and entered 40 hours in B4. Cell D4 (=168-B$) didn't update and neither did the chart. Is excel on strike?