Excel Column Chart with Data Tables

  • Thread starter Thread starter wknych
  • Start date Start date
W

wknych

I have created a column chart and would lik to add a table at the
bottom of the chart, exactly like a data table but one that I can
manipulate. I want to be able to type in my own numbers in the table.

Specifically, I'm showing annual returns in the columns and want to
show standard deviation in a table.

Is this possible?

Thanks.
 
Could you accept using a worksheet range for this data table? I thought you
could.

The last and third to last screen shot on this web page show how I've
programmed a utility to align calculated values beneath columns of a chart:

http://peltiertech.com/Excel/Charts/BoxWhisker.html

It wasn't too complicated. The worksheet columns are of uniform width, and
the utility makes the chart one column wider on either side to allow for
margins in the chart. You may need two columns, or a single wider column, on
the left if the vertical axis requires more room. Then the code aligns the
edges of the plot area so that the plot area spans the categories of the
chart. I've done the same (no pictures, sorry) with a horizontal bar chart
and worksheet rows.

- Jon
 
Back
Top