Combo Chart - linking data to different data points

MrAWilks

New Member
Joined
Mar 23, 2021
Messages
3
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
I have attempted to attach the mini sheet below with a Data Input table in which I have created.

All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc.

The cells in the ticks column is a manual entry.

Book1
ABCDEFGHIJKLMNOP
1Year 1
2Autumn 1Autumn 2Spring 1Spring 2Summer 1Summer 2
3Name:StandardTicksStandardTicksStandardTicksStandardTicksStandardTicksStandardTicks
4Child AYear 18.00Year 113.00Year 115.00Year 119.00Year 25.00Year 27.00
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39Year 1
40Year 2
41Year 3
42Year 4
43Year 5
44Year 6
Data Input
Cells with Data Validation
CellAllowCriteria
M4:M34List=$E$39:$E$44
E4:E33List=$E$39:$E$44
G4:G34List=$E$39:$E$44
I4:I34List=$E$39:$E$44
K4:K34List=$E$39:$E$44
O4:O34List=$E$39:$E$44


I would like this data to link to another sheet, the one that is hopefully attached below.

Book1
ABCDEF
1Not yet at StandardDevelopingSecureAdvanced
2Year 1 StandardAutumn 15483
3Autumn 25483
4Spring 15483
5Spring 25483
6Summer 15483
7Summer 25483
8
9Year 2 StandardAutumn 15483
10Autumn 25483
11Spring 15483
12Spring 25483
13Summer 15483
14Summer 25483
15
16Year 3 StandardAutumn 15483
17Autumn 25483
18Spring 15483
19Spring 25483
20Summer 15483
21Summer 25483
22
23Year 4 StandardAutumn 15483
24Autumn 25483
25Spring 15483
26Spring 25483
27Summer 15483
28Summer 25483
29
30Year 5 StandardAutumn 15483
31Autumn 25483
32Spring 15483
33Spring 25483
34Summer 15483
35Summer 25483
36
37Year 6 StandardAutumn 15483
38Autumn 25483
39Spring 15483
40Spring 25483
41Summer 15483
42Summer 25483
Child A


The issue is where in Summer 1, Child A has moved up from the Year 1 Standard to the Year 2 Standard, I would like that to be shown as such in the Combo Chart which I have attached.

I'll be honest I do not have any ideas how to do this so any help would be greatly appreciated!
 

Attachments

  • Annotation 2021-03-26 134511.png
    Annotation 2021-03-26 134511.png
    20.5 KB · Views: 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,132,973
Messages
5,656,174
Members
418,284
Latest member
LaurentT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top