Is it possible to have a custom data table visible underneath a chart in MS Excel?

Question

I have a column chart with a single series of data to be shown on the chart.

However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I want to show it as a data table beneath the chart.

Right now, every time I add a data-table to the chart and poke around its options, I can only ever get the data for the series that are actually being charted, and not additional columnar data. Ideally, I could exclude the data that is already charted (to avoid redundancy) and add the other column for use only in the data table. But it seems the data table is inexorably tied to what you actually see in the cart.

Is this possible? I know there are lots of tricks for massaging Excel into doing what you want, but so far it has eluded me. (Excel 2007)

Answer 1

You can set the ChartArea and PlotArea properties to NoFill to make them transparent. Then place to chart on top of a range containig the table

Answer 2

Not sure if this is the direction you want, but, you could copy your desired cell range as a picture, then paste the picture anywhere you like.

In Excel 2007 you'd select the desired cell range, copy it, then on the "Home" tab, choose "Paste", "As Picture", "Copy as Picture", and accept the defaults. This copies the selected range as a picture to your clipboard, and now you can paste it anywhere. You can further manipulate the picture properties at this point if needed.

You can "paste as picture" a lot of things -- including pictures of graphs.

You can automate it with a macro as well.