Can I add a non related data table to the bottom of a graph 2007 or 2010

[phendri3]

I was wondering if I can add a non related data table to the bottom of a graph, that aligns with the axis labels. (Like the graphs data table option in layouts.)

I basically have a line graph charting the "% met target." I want to add a data table that shows the data used to calculate the %.

My data looks like:

A B C D
1 Met target =< 4hrs 34 208 147
2 Not Met >4hrs 7 67 48
3 Total 41 275 195
4
5 "% Met target" 83% 76% 75%

The graph series uses row 5 and I would like the table to display rows 1-3.

I have tried adding a text box with the range A1:D3, but I only get the value in A1 and it isn't formatted.

I have both excel 2007 and 2010.

I hope this makes sense, I would really appreciate if anyone could help me.

Thank you.

 

[Steve=True]

You will need to have your chart as a Object in a Sheet vs a sheet by itself.

Just put your data table in a blank area of the sheet and put your graph above it.

Excel tables are very non-flexible and should probably be avoided.

 

[phendri3]

Thanks Steve=True, this is what I have done. I was wondering if there was just something that I was missing.
Thank you for your time.