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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Bob Barnes" wrote in message
...
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

"Shane Devenshire" wrote:

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.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bob Barnes" wrote:

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