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
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
| Year | Each Quarter | Percentage Results |
| 2007 | Q1 | 55 |
| 2007 | Q2 | 58 |
| 2007 | Q3 | 59 |
| 2007 | Q4 | 60 |
| 2008 | Q1 | 51 |
| 2008 | Q2 | 56 |
| 2008 | Q3 | 62 |
| 2008 | Q4 | 50 |
| 2009 | Q1 | 55 |
| 2009 | Q2 | 53 |
| 2009 | Q3 | 55 |
| 2009 | Q4 | 60 |
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
