Can I split data series in an excel chart?
I am trying to create a comparative bar chart with year-on-year quarterly
sales figures for three different branches of a company. There are three divisional figures and a subsequent total for each quarter of each of the three years. The separate series need to be the years but each quarter total needs to be visually split by the three divisions (sales quarters along the x-axis, £ along the y-axis, 3 separate bars for each quarter each representing a year and each split into 3 sections by division) I can't work out how to do it or even if it is possible to split the series in this way? Thanks |
All times are GMT +1. The time now is 08:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com