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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|