ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Two colors in stacked bar chart (https://www.excelbanter.com/charts-charting-excel/453205-two-colors-stacked-bar-chart.html)

Karsten Markmann

Two colors in stacked bar chart
 
Hi there
Does anyone know if it's possible only to have two different colors in a stacked bar chart?

From the dataset below I want one stacked bar
Pr 24 hours. The due colum is the vertical size of the stack in minutes. The on colum determines if the bar should be red or fax blue.
Anybody knows if this is possible in excel?
Kind regards
Karsten Markmann

Time. Name. Due. On
22-02-2017 21:03 Maskine3 15 FALSK
22-02-2017 23:59 Maskine3 176 SAND
23-02-2017 00:00 Maskine3 0 SAND
23-02-2017 07:05 Maskine3 425 SAND
23-02-2017 07:28 Maskine3 23 SAND
23-02-2017 19:55 Maskine3 746 SAND
23-02-2017 19:55 Maskine3 0 FALSK
23-02-2017 23:59 Maskine3 244 SAND
24-02-2017 00:00 Maskine3 0 SAND
24-02-2017 02:19 Maskine3 139 SAND
24-02-2017 12:48 Maskine3 628 SAND
24-02-2017 23:59 Maskine3 671 SAND
25-02-2017 00:00 Maskine3 0 SAND


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com