Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Charts don't update when data changes | Charts and Charting in Excel | |||
Help with pivot charts and data labels | Charts and Charting in Excel |