Nirubiha has attended:
Excel Intermediate course
Table
Hi,
I've 4 measures for ex M1, M2, M3 and M4 and this is done by 10 different people and each of the M1, M2, M3 and M4 measured in triplicate.
I would like to put this in a graph (in a "column" not "scatter") in a way that all the measures of M1 from 10 different peolpes are together, M2 together etc.
Finally in my graph, i will have 4 different pattern and each of them will have 10 different size of columns.
Please let me know how can i proceed with this.
kind Regards,
Niru
RE: Table
Hi Niru,
Thank you for the forum question.
I hope that I understand what you want.
I have attached a workbook with an example. In sheet 1 you will find 4 tables of data (triplicate measures from 10 persons). To get the data in a column chart you will need to add them in a table (my table 4). I selected the table where I add up the 3 tables and on the insert tab in the charts group I clicked Column and selected the second option "stacked column".
I hope this can help you but please let me know if it is not what you want.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Table
Hi Niru,
To create the chart in your example is not straight forward.
You need to select a blank cell and all cells around the blank cell most be blank too. Insert the column chart (the first chart type under column charts). You will get a empty chart.
Make sure the empty chart is selected now click SELECT DATA on the DESIGN tab. In the SELECT DATA SOURCE dialog box click ADD. In series name type the name of the series (Eaglescliffe - Black Tea Lab). In series values make sure that you delete what you have in the box (={1}). Do not try to overwrite it must be selected and deleted. Click in the box series values and click in C15 in the worksheet. Press down the CTRL key and keep it down. Now click in C20,C25 and C30.
Release the CTRL key and click OK.
You will need to do the same for all the series you want to see in the chart.
After you have added all the series you need to click EDIT under Horizontal (Category) axis labels and in the box type.
={"BD-001","BD-002","BD-003","BD-004"}
I hope that you can make the chart now. Good luck.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
