Inserting a dynamic table(s) or textbox(s) to the right of a horizontal bar chart

[som3on3_10]

I currently have an overlapping horizontal bar chart where I need to insert 1 or 2 tables to the right. I have attached a sample file. Currently the fields Type 1 and Type 2 are dynamic and are pulled into the chart as data series depending on what the data is in columns B and C. However the fields Type 3 and Type 4 are manually being inputted into the text box to the right. Is there a way to show a bar chart in a similar fashion that I have laid out where Type 3 and Type 4 will automatically update depending on what the data in columns D and E are? Not only is the current way manual, but the numbers aren't perfectly aligned with the categories (Category 1, Category 2, etc.). This would save me a lot of time and heartache every month. TIA!

[protonLeah]

One option is to just add the two types and set the line and fill options to none, and uncheck VALUE for the data labels. Then choose Add Data Table option.

[som3on3_10]

Thanks for the reply proton, but I have to keep it in the same format where there is only a table or two to the right of the chart. And I wouldn't be able to duplicate anything that is already in the bar chart on this table (like Type 1 and Type 2 for example). Any other thoughts/ideas? Thanks.

[Andy Pope]

You could use additional xy series to build the table.
Use data labels, showing series name.

If you don't want the horizontal axis to appear underneath the table you can use additional xy series to draw and label a shortened axis.
The bordering of the table can also be done using more xy series.