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
|
|||
|
|||
quickly select data to produce charts
Hi
We need to produce charts comparing different variables. The data layout is simple: Item 1 Item2 Item 3 - & so on 2.3 1.2 3.5 1.1 2.3 4.2 There is up to 12 columns and 20 rows. All need to be compared against each other. Is there a way to choose two variables and then have these updat einto a chart? i.e 1 compared with 2, 1 compared with 3 then 4 and so on I found examples with drop down boxes for one varaible but not two Help appreciated |
#2
|
|||
|
|||
quickly select data to produce charts
Can't you extend the example to the second variable?
Andy Pope shows another approach on his web site: a matrix of smaller charts, plotting each variable against each other: http://andypope.info/charts/miniplot_xy.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "kim" wrote in message ... Hi We need to produce charts comparing different variables. The data layout is simple: Item 1 Item2 Item 3 - & so on 2.3 1.2 3.5 1.1 2.3 4.2 There is up to 12 columns and 20 rows. All need to be compared against each other. Is there a way to choose two variables and then have these updat einto a chart? i.e 1 compared with 2, 1 compared with 3 then 4 and so on I found examples with drop down boxes for one varaible but not two Help appreciated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
charts lose data | Steve | Powerpoint | 0 | January 28th, 2005 06:13 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |