Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
complex chart
Hi!
I have the table below, containing 2 Y-values per X-value, i.e. a minimum value and a maximum value for every period (X-axis). There are 6 periods. values from different series can overlap. What is the best way (graph type) to present this table? I guess some tricks should be involved. 1975/1980 1981/1985 1986/1990 a 2500 2700 2700 2900 2900 3000 b 2500 2700 2700 3000 2900 3000 c 2500 2700 2700 2900 3000 3200 d 2800 3000 3000 3100 3200 3500 e 2800 3000 3000 3100 3500 3700 f 2500 2700 2700 3000 3200 3500 g 2500 2700 2700 3000 3200 3400 h 3000 3200 3300 3500 3500 4000 i 3000 3200 3300 3500 4000 4200 j 3500 3600 3700 3800 4500 4700 k 3300 3500 3500 3600 4300 4700 l 5000 5200 5500 6500 m 0 0 5000 6000 6000 7000 n 3700 3700 3900 4000 4500 hope someone knows an acceptable answer.. Thanks! tom |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
complex chart
some clearification:
shown are three periods, but achtually there are 6.. "tom ossieur" wrote: Hi! I have the table below, containing 2 Y-values per X-value, i.e. a minimum value and a maximum value for every period (X-axis). There are 6 periods. values from different series can overlap. What is the best way (graph type) to present this table? I guess some tricks should be involved. 1975/1980 1981/1985 1986/1990 a 2500 2700 2700 2900 2900 3000 b 2500 2700 2700 3000 2900 3000 c 2500 2700 2700 2900 3000 3200 d 2800 3000 3000 3100 3200 3500 e 2800 3000 3000 3100 3500 3700 f 2500 2700 2700 3000 3200 3500 g 2500 2700 2700 3000 3200 3400 h 3000 3200 3300 3500 3500 4000 i 3000 3200 3300 3500 4000 4200 j 3500 3600 3700 3800 4500 4700 k 3300 3500 3500 3600 4300 4700 l 5000 5200 5500 6500 m 0 0 5000 6000 6000 7000 n 3700 3700 3900 4000 4500 hope someone knows an acceptable answer.. Thanks! tom |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
complex chart
That partially clearifies it. What's the significance of the letters down
the leftmost column of your table? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "tom ossieur" wrote in message ... some clearification: shown are three periods, but achtually there are 6.. "tom ossieur" wrote: Hi! I have the table below, containing 2 Y-values per X-value, i.e. a minimum value and a maximum value for every period (X-axis). There are 6 periods. values from different series can overlap. What is the best way (graph type) to present this table? I guess some tricks should be involved. 1975/1980 1981/1985 1986/1990 a 2500 2700 2700 2900 2900 3000 b 2500 2700 2700 3000 2900 3000 c 2500 2700 2700 2900 3000 3200 d 2800 3000 3000 3100 3200 3500 e 2800 3000 3000 3100 3500 3700 f 2500 2700 2700 3000 3200 3500 g 2500 2700 2700 3000 3200 3400 h 3000 3200 3300 3500 3500 4000 i 3000 3200 3300 3500 4000 4200 j 3500 3600 3700 3800 4500 4700 k 3300 3500 3500 3600 4300 4700 l 5000 5200 5500 6500 m 0 0 5000 6000 6000 7000 n 3700 3700 3900 4000 4500 hope someone knows an acceptable answer.. Thanks! tom |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
complex chart
those are vessel types.. every row is the cost development for one vessel type
"Jon Peltier" wrote: That partially clearifies it. What's the significance of the letters down the leftmost column of your table? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "tom ossieur" wrote in message ... some clearification: shown are three periods, but achtually there are 6.. "tom ossieur" wrote: Hi! I have the table below, containing 2 Y-values per X-value, i.e. a minimum value and a maximum value for every period (X-axis). There are 6 periods. values from different series can overlap. What is the best way (graph type) to present this table? I guess some tricks should be involved. 1975/1980 1981/1985 1986/1990 a 2500 2700 2700 2900 2900 3000 b 2500 2700 2700 3000 2900 3000 c 2500 2700 2700 2900 3000 3200 d 2800 3000 3000 3100 3200 3500 e 2800 3000 3000 3100 3500 3700 f 2500 2700 2700 3000 3200 3500 g 2500 2700 2700 3000 3200 3400 h 3000 3200 3300 3500 3500 4000 i 3000 3200 3300 3500 4000 4200 j 3500 3600 3700 3800 4500 4700 k 3300 3500 3500 3600 4300 4700 l 5000 5200 5500 6500 m 0 0 5000 6000 6000 7000 n 3700 3700 3900 4000 4500 hope someone knows an acceptable answer.. Thanks! tom |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
complex chart
With respect to the chart, I meant. Are they category labels, or do they
indicate different series of data? I am not sure I understand how you want the chart to look. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "tom ossieur" wrote in message ... those are vessel types.. every row is the cost development for one vessel type "Jon Peltier" wrote: That partially clearifies it. What's the significance of the letters down the leftmost column of your table? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "tom ossieur" wrote in message ... some clearification: shown are three periods, but achtually there are 6.. "tom ossieur" wrote: Hi! I have the table below, containing 2 Y-values per X-value, i.e. a minimum value and a maximum value for every period (X-axis). There are 6 periods. values from different series can overlap. What is the best way (graph type) to present this table? I guess some tricks should be involved. 1975/1980 1981/1985 1986/1990 a 2500 2700 2700 2900 2900 3000 b 2500 2700 2700 3000 2900 3000 c 2500 2700 2700 2900 3000 3200 d 2800 3000 3000 3100 3200 3500 e 2800 3000 3000 3100 3500 3700 f 2500 2700 2700 3000 3200 3500 g 2500 2700 2700 3000 3200 3400 h 3000 3200 3300 3500 3500 4000 i 3000 3200 3300 3500 4000 4200 j 3500 3600 3700 3800 4500 4700 k 3300 3500 3500 3600 4300 4700 l 5000 5200 5500 6500 m 0 0 5000 6000 6000 7000 n 3700 3700 3900 4000 4500 hope someone knows an acceptable answer.. Thanks! tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For complex dashboard: What type of chart to use? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |