Help with charts please

[Auro]

Hi,


I am trying to make a combined chart - stacked column chart with line. I have to build the chart with the following variables.


Department name

Weeks

No of jobs

No of jobs within a Job

Time taken

Capacity of department


Sorry, for some reason I am not able to attache the file.


Thanks!!

 

[Luke M]

First, how to post a workbook:

http://chandoo.org/forums/topic/posting-a-sample-workbook


To make a combined chart, start with all the series loaded, in the stacked column chart type you want. Then, select a single series, right click, select chart type, and change it to line. Repeat as needed.


Additionally, this might help:

http://peltiertech.com/Excel/Charts/AddLine.html

 

[Auro]

Hi Luke,


Thanks for the help. I have now uploaded the file in google docs and here is the link:


https://docs.google.com/spreadsheet/ccc?key=0AtFADdE96rZtdEtTM3daSm5lQmVVUjEzdkxSeG1TMnc


In the meantime I would look into peltiertech.


Thanks!

 

[Auro]

Hi all,


Tried (http://peltiertech.com/Excel/Charts/AddLine.html)didn't really help me. It confused me even more. Any sorta help would be appreciated.


Thanks!

 

[srinidhi]

select the data click on 2D Column chart next u will get the stack chart, The dept name & Week will come on X axis & select the stack with u want to convert into a line, right click Change series chart type & select the line chart