P pm1978 New Member Mar 1, 2017 #1 Please help with graph. Requirement is in attached word file. Attachments New Microsoft Word Document.docx 20.9 KB · Views: 6
Chihiro Excel Ninja Mar 1, 2017 #2 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: 18
You'd use stacked bar chart with 1st series (From), with no fill/transparent. However, you'd need helper column. See attached.
P pm1978 New Member Mar 3, 2017 #3 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.
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.
Chihiro Excel Ninja Mar 5, 2017 #4 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.
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.