View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default 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.