ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   chart with stacked columns in pairs (https://www.excelbanter.com/charts-charting-excel/64098-chart-stacked-columns-pairs.html)

beardedoldness

chart with stacked columns in pairs
 
Fred's time in first row, Fred's technician's hours in row 2. Bill's time in
third row, Bill's tech in row 4. Columns Jan to Dec. Chart wanted - two
stacked cols for each month. How? Please. Richard.
or Hotmail

Andy Pope

chart with stacked columns in pairs
 
Hi,

You will need to adjust your data layout.
Check Jon's page for links to various explanations.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

beardedoldness wrote:
Fred's time in first row, Fred's technician's hours in row 2. Bill's time in
third row, Bill's tech in row 4. Columns Jan to Dec. Chart wanted - two
stacked cols for each month. How? Please. Richard.
or Hotmail


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 12:38 PM.

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