Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Fan charts | Charts and Charting in Excel |