Excel Chart with Corresponding Table Below

[Rcaaa]

Hello,

Does anyone know how to have the axis of the graph be a table?

The example of the table is below. I would want a line/bar graph to use the months as the axis and the color of the Monthly Actuals and Monthly Budget to be the same as what is used in the graph.


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Oct
[/TD]
[TD]November
[/TD]
[TD]December
[/TD]
[TD]January
[/TD]
[TD]February
[/TD]
[TD]March
[/TD]
[/TR]
[TR]
[TD]Monthly Actuals
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Monthly Budget
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks a million,

RCAAA

 

[Rcaaa]

I figured it out, but I will leave it up for anyone who has the same question.

1. Click on the chart
2. Click the Design Tab
3. Click on the Add Chart Element
4. Select Data tables

(The image will show the drop down that has data tables)