A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Table at Base of Chart



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2009, 01:48 AM posted to microsoft.public.excel.charting
Bob Barnes
external usenet poster
 
Posts: 538
Default Data Table at Base of Chart

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
  #2  
Old March 5th, 2009, 09:18 AM posted to microsoft.public.excel.charting
Shane Devenshire
external usenet poster
 
Posts: 845
Default Data Table at Base of Chart

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

  #3  
Old March 5th, 2009, 04:39 PM posted to microsoft.public.excel.charting
Bob Barnes
external usenet poster
 
Posts: 538
Default Data Table at Base of Chart

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

  #4  
Old March 6th, 2009, 03:07 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Data Table at Base of Chart

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



  #5  
Old March 6th, 2009, 04:44 PM posted to microsoft.public.excel.charting
Bob Barnes
external usenet poster
 
Posts: 538
Default Data Table at Base of Chart

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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.