Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic charting
Hi
I have to update a weekly spreadsheet With week numbers in column B x series and three y series percentages in G,H,I columns. Could someone please help I need these to update automatically. If someone can explain in detail I would appreciate 39 2097 2165 68 1770.7 97 96.86 118.43 40 2443.15 2201 -242.15 1548.93 97 111.00 157.73 41 2162.83 2259 96.17 1600.78 97 95.74 135.11 42 2163.08 2241 77.92 1545.1 97 96.52 140.00 43 2137.5 2271 133.5 1664.6 97 94.12 128.41 44 2160.67 2298 137.33 1455 97 94.02 148.50 Ta Brian |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic charting
Dynamic charts are discussed in these sites:
http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://office.microsoft.com/en-us/ex...098011033.aspx http://people.stfx.ca/bliengme/ExcelTips/Dynamic.htm Also if you have Excel 2003 and you turn the data you chart into a List (select all the data and use Data | List | Create) then the chart is automatically dynamic. Works only when the x-values are in a column (as you have) not in a row. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Hi I have to update a weekly spreadsheet With week numbers in column B x series and three y series percentages in G,H,I columns. Could someone please help I need these to update automatically. If someone can explain in detail I would appreciate 39 2097 2165 68 1770.7 97 96.86 118.43 40 2443.15 2201 -242.15 1548.93 97 111.00 157.73 41 2162.83 2259 96.17 1600.78 97 95.74 135.11 42 2163.08 2241 77.92 1545.1 97 96.52 140.00 43 2137.5 2271 133.5 1664.6 97 94.12 128.41 44 2160.67 2298 137.33 1455 97 94.02 148.50 Ta Brian |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic charting
On Nov 10, 9:35 pm, "Bernard Liengme"
wrote: Dynamic charts are discussed in these sites:http://peltiertech.com/Excel/Charts/...ps/Dynamic.htm Also if you have Excel 2003 and you turn the data you chart into a List (select all the data and use Data | List | Create) then the chart is automatically dynamic. Works only when the x-values are in a column (as you have) not in a row. best wishes -- Bernard V Liengme Microsoft Excel MVPwww.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Hi I have to update a weekly spreadsheet With week numbers in column B x series and three y series percentages in G,H,I columns. Could someone please help I need these to update automatically. If someone can explain in detail I would appreciate 39 2097 2165 68 1770.7 97 96.86 118.43 40 2443.15 2201 -242.15 1548.93 97 111.00 157.73 41 2162.83 2259 96.17 1600.78 97 95.74 135.11 42 2163.08 2241 77.92 1545.1 97 96.52 140.00 43 2137.5 2271 133.5 1664.6 97 94.12 128.41 44 2160.67 2298 137.33 1455 97 94.02 148.50 Ta Brian- Hide quoted text - - Show quoted text - Thankyou very much, Really helpfull as an MBA Grad/ working in industrial engineering this is really useful. I have completed what I needed to do. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic charting
Thanks for feedback
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic charting | Charts and Charting in Excel | |||
Dynamic Charting - i think! | Charts and Charting in Excel | |||
Dynamic Charting | Charts and Charting in Excel | |||
Dynamic Charting | Excel Discussion (Misc queries) | |||
Dynamic charting | Excel Discussion (Misc queries) |