Table of data on chart with different data displayed

[Gavalar]

Hi Folks

I have a workbook which I have used to generated 4 graphs however I also now want to include a data table on the graph. I have tried the "Add element" in chart layouts but have been unsuccessful in getting what I require because the way the table is populated, excel uses the same data as the graph. I would like the table to use a different data set from different columns.
I have attached the workbook and would like a table under all 4 graphs to show the data from columns B,C,D. Does anyone know if this can be done? and if so how?

I don't really want to include the data for these columns (Into the graph) and then no fill the areas on the bar graph, as the graph is busy enough. I am also worried if I do it that way the table would be an info overload as I have considered this option.

Many thanks in advance

Gav

[dflak]

I did this manually. Take a look at it to see if it is what you want. Once you confirm, I'll see if I can figure out how to do it automatically.

[Gavalar]

Many thanks for your efforts but I think I may have been a little weak in my explanation on this so I've experimented a bit more to demonstrate better and attached is an updated spreadsheet. As you can see the table is beneath the graph however there are 2 problems with how I've achieved this and the final layout that I don't really want.

1- There are 3 bar graphs present that are coloured as "no Fill" that I really don't want there so would like the bar graph part removed while at the same time keeping the values in the table
2- There are the 2 higlighted rows at the bottom of the Table that I would also rather not be where they are can these be removed without affecting the graph

I'm not sure the functionality of graphs allows this to be done and I may have to make do.

Any ideas?