| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar chart question?
I have a list with names and values as follows:
A B Law 22 Low 5 and so on for 34 rows. But the list can very in size. I have a chart that takes the data from this list, but I can only have the source "1 to 34" rows. Is there a way that the chart veries with the size of the list? -- Bob |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart question?
You need to explore the concept of 'dynamic chart'
Start he http://peltiertech.com/Excel/Charts/Dynamics.html If you need more Google <excel dynamic chart' If you have Excel 2007, it is every easy: just select the data used for the chart and make it an Excel Table. The chart with expand/contract with the Table. See http://www.microsoft.com/learning/en...oks/12284.aspx best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob" wrote in message ... I have a list with names and values as follows: A B Law 22 Low 5 and so on for 34 rows. But the list can very in size. I have a chart that takes the data from this list, but I can only have the source "1 to 34" rows. Is there a way that the chart veries with the size of the list? -- Bob |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart question?
Excel 2003 has its "List", which for the purposes of a dynamic data range
(i.e., source data for a chart) works just like an Excel 2007 table. Select the range, and press CTRL+L. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ ## 2 Weeks Left! Don't Miss It! Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bernard Liengme" wrote in message ... You need to explore the concept of 'dynamic chart' Start he http://peltiertech.com/Excel/Charts/Dynamics.html If you need more Google <excel dynamic chart' If you have Excel 2007, it is every easy: just select the data used for the chart and make it an Excel Table. The chart with expand/contract with the Table. See http://www.microsoft.com/learning/en...oks/12284.aspx best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob" wrote in message ... I have a list with names and values as follows: A B Law 22 Low 5 and so on for 34 rows. But the list can very in size. I have a chart that takes the data from this list, but I can only have the source "1 to 34" rows. Is there a way that the chart veries with the size of the list? -- Bob |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart question?
That I had forgotten. Thanks, Jon
-- Bernard "Jon Peltier" wrote in message ... Excel 2003 has its "List", which for the purposes of a dynamic data range (i.e., source data for a chart) works just like an Excel 2007 table. Select the range, and press CTRL+L. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ ## 2 Weeks Left! Don't Miss It! Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bernard Liengme" wrote in message ... You need to explore the concept of 'dynamic chart' Start he http://peltiertech.com/Excel/Charts/Dynamics.html If you need more Google <excel dynamic chart' If you have Excel 2007, it is every easy: just select the data used for the chart and make it an Excel Table. The chart with expand/contract with the Table. See http://www.microsoft.com/learning/en...oks/12284.aspx best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob" wrote in message ... I have a list with names and values as follows: A B Law 22 Low 5 and so on for 34 rows. But the list can very in size. I have a chart that takes the data from this list, but I can only have the source "1 to 34" rows. Is there a way that the chart veries with the size of the list? -- Bob |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart question?
Thanks very much I shall look it up
-- Bob "Bernard Liengme" wrote: That I had forgotten. Thanks, Jon -- Bernard "Jon Peltier" wrote in message ... Excel 2003 has its "List", which for the purposes of a dynamic data range (i.e., source data for a chart) works just like an Excel 2007 table. Select the range, and press CTRL+L. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ ## 2 Weeks Left! Don't Miss It! Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bernard Liengme" wrote in message ... You need to explore the concept of 'dynamic chart' Start he http://peltiertech.com/Excel/Charts/Dynamics.html If you need more Google <excel dynamic chart' If you have Excel 2007, it is every easy: just select the data used for the chart and make it an Excel Table. The chart with expand/contract with the Table. See http://www.microsoft.com/learning/en...oks/12284.aspx best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob" wrote in message ... I have a list with names and values as follows: A B Law 22 Low 5 and so on for 34 rows. But the list can very in size. I have a chart that takes the data from this list, but I can only have the source "1 to 34" rows. Is there a way that the chart veries with the size of the list? -- Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pie chart question | Excel Discussion (Misc queries) | |||
| A chart question | Excel Discussion (Misc queries) | |||
| how to chart question | Charts and Charting in Excel | |||
| bar chart question | Charts and Charting in Excel | |||
| pie chart question..... | Charts and Charting in Excel | |||
Linear Mode
