Data Table at Base of Chart

[Bob Barnes]

I'm using Access-to-Excel automation to build a Pareto Stacked Bar Chart w/
31 variables.

I would like to have ALL 31 variables in the Data Table at the foot of the
Chart. NOT really concerned with how the Stacked Bar Chart looks, but rather
looking at the Counts in the Data Table.

I had automated 17 of the 31 variables, and noticed apparently a Data Table
nicely displays 10 to 12 "Series", but truncates as more Series are added.

Is there a way I can display ALL 31 varaiables in the Data table??

Would also like to utilize a Legend at the Top of the Chart. I am able to
change the size of the Legend and might be able to assign "Totals" for the 31
variables in the Chart's Legend.

Thoughts? TIA - Bob

 

[Shane Devenshire]

Hi,

Bad news - the data tables in charts are notoriously difficult to work with
because we don't have much control of them. It is very unlikely that you can
get all 31 on screen at one time, but here is what you can try: 1. Reduce
the font size, 2. Abbreviate long labels, 3. Increase the width of the chart,
4. Increase the width of the Plot area.

My choice - create the equivalent of the data table directly below the chart
in the spreadsheet. You can do anything here!

I not sure what you other question is? If you want the legend at the top of
the chart right click the legend and choose Format Legend, Placement tab...
or you can drag it anywhere you want it. To add the values to the legend you
would need to change the names of the series. Suppose the legend entry reads
Texas is in A1 and the value you want is in B1 then in C1 you would use a
formula like

=A1&" - "&B1

Then you will need to chart the range B1:C10 ignoring column A.

 

[Bob Barnes]

Shane - thank you..a further question on your...
My choice - create the equivalent of the data table directly below the chart
in the spreadsheet. You can do anything here!

The "substitute Data Table" will have the 31 variables spread out over 21
categories of the Pareto charts...in other words 31 x 21 "cells" = 651 cells
to populate. I'm sure I can Program that...however, is there an Excel object
like a 'Subform" or "DataGrid" that would nicely place these "Series Values"
w/o further Programming??

TIA - Bob

 

[Jon Peltier]

is there an Excel object

like a 'Subform" or "DataGrid" that would nicely place these "Series
Values"
w/o further Programming??

It's called a worksheet. In its cells you can put formulas that link to the
source. If your source data is reasonably nicely laid out, these formulas
will be straightforward.

- Jon

 

[Bob Barnes]

Thanks Jon - It sure would have been nice to utilize the Chart's "Data Table".