| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to plot column chart with one series against multiple series.
I want to plot a coloumn chart. my x-axis is fixed. my y axis consist of many
columns. i want to plot the first column and combine all the other column so that it is adjacent to first column. for example my x axis will be month. my y axis first column will be income. other columns will be expenses. i want a graph in such a way that i can compare all the expenses together with the income. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to plot column chart with one series against multiple series.
Try plotting you data like this . . .
Assume the following resides in the range A1:C4: (A1) Income (B1) $15 (A2) Salaries (C2) $4 (A3) Supplies (C3) $6 (A4) Services (C4) $5 Select the range. In the Chart Wizard step 1, choose the Stacked Column chart option. In step 2, choose "Series in Rows". To crease more than one month, carry this same type of logic out to columns D, E, etc. -- John Mansfield http://cellmatrix.net "svenkateshmurthy" wrote: I want to plot a coloumn chart. my x-axis is fixed. my y axis consist of many columns. i want to plot the first column and combine all the other column so that it is adjacent to first column. for example my x axis will be month. my y axis first column will be income. other columns will be expenses. i want a graph in such a way that i can compare all the expenses together with the income. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to plot column chart with one series against multiple seri
Bernard Liengme provides a much better example below:
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm It is based on Stephen Bullen's original work. -- John Mansfield http://cellmatrix.net "John Mansfield" wrote: Try plotting you data like this . . . Assume the following resides in the range A1:C4: (A1) Income (B1) $15 (A2) Salaries (C2) $4 (A3) Supplies (C3) $6 (A4) Services (C4) $5 Select the range. In the Chart Wizard step 1, choose the Stacked Column chart option. In step 2, choose "Series in Rows". To crease more than one month, carry this same type of logic out to columns D, E, etc. -- John Mansfield http://cellmatrix.net "svenkateshmurthy" wrote: I want to plot a coloumn chart. my x-axis is fixed. my y axis consist of many columns. i want to plot the first column and combine all the other column so that it is adjacent to first column. for example my x axis will be month. my y axis first column will be income. other columns will be expenses. i want a graph in such a way that i can compare all the expenses together with the income. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i plot series in a stacked chart in excel | Charts and Charting in Excel | |||
| plot multiple time series | Charts and Charting in Excel | |||
| multiple rows and column, chart into 1 series? | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
Linear Mode
