• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart required, dont know the chart type, visualization provided. Please help. TIA.

pm1978

New Member
Please help with graph. Requirement is in attached word file.
 

Attachments

  • New Microsoft Word Document.docx
    20.9 KB · Views: 6
You'd use stacked bar chart with 1st series (From), with no fill/transparent.

However, you'd need helper column.

See attached.
 

Attachments

  • Sample_DateChart.xlsb
    13.4 KB · Views: 17
Hi, Thanks a ton. I was trying to do the same thing but couldn't select the data as required in the chart. Please provide steps of data selection for my understanding. Thanks again.
 
You use Ctrl to select non-contiguous ranges.

You can also edit series formula.
=SERIES(Sheet1!$C$1,Sheet1!$A$2:$A$6,Sheet1!$D$2:$D$6,2)

Another method is to create 2 separate chart then paste one into the other.
 
Back
Top