Dear All,
I need small help in excel charts, I have tried and I was able to plot using only two columns but not with the three columns. Below is my three sets of data
[TABLE="width: 207"]
[TR]
[TD]Year[/TD]
[TD]Each Quarter[/TD]
[TD]Percentage Results[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q1[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q2[/TD]
[TD]58[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q3[/TD]
[TD]59[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q4[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q1[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q2[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q3[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q4[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q1[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q2[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q3[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q4[/TD]
[TD]60[/TD]
[/TR]
[/TABLE]
I would like to plot in "x - axis" as Year & Each Quarter combination and "y-axis" as Percentage Results and I would like all the plots as line chart and must be overlaid. By clicking each plot I would like to see only four "percentage results" for particular year. Is that possible to do values in three columns with two series of chart type.
Kind RegardsSoemesh
I need small help in excel charts, I have tried and I was able to plot using only two columns but not with the three columns. Below is my three sets of data
[TABLE="width: 207"]
[TR]
[TD]Year[/TD]
[TD]Each Quarter[/TD]
[TD]Percentage Results[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q1[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q2[/TD]
[TD]58[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q3[/TD]
[TD]59[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]Q4[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q1[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q2[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q3[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]2008[/TD]
[TD]Q4[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q1[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q2[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q3[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]Q4[/TD]
[TD]60[/TD]
[/TR]
[/TABLE]
I would like to plot in "x - axis" as Year & Each Quarter combination and "y-axis" as Percentage Results and I would like all the plots as line chart and must be overlaid. By clicking each plot I would like to see only four "percentage results" for particular year. Is that possible to do values in three columns with two series of chart type.
Kind RegardsSoemesh