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 |