hide/unhide

[JOEE1979]

I have this chart I would like to display on a page

Weekday Bus Cycling - Master - Copy.xlsm
	AE	AF	AG	AH	AI
4	0:01	-	0:30	0	0
5	0:31	-	1:00	0	0
6	1:01	-	1:30	0	0
7	1:31	-	2:00	0	0
8	2:01	-	2:30	0	0
9	2:31	-	3:00	0	0
10	3:01	-	3:30	0	0
11	3:31	-	4:00	0	0
12	4:01	-	4:30	0	0
13	4:31	-	5:00	0	0
14	5:01	-	5:30	0	0
15	5:31	-	6:00	0	0
16	6:01	-	6:30	0	0
17	6:31	-	7:00	0	0
18	7:01	-	7:30	0	0
19	7:31	-	8:00	0	0
20	8:01	-	8:30	0	0
21	8:31	-	9:00	0	0
22	9:01	-	9:30	0	0
23	9:31	-	10:00	0	0
24	10:01	-	10:30	0	0
25	10:31	-	11:00	0	0
26	11:01	-	11:30	0	0
27	11:31	-	12:00	0	0
28	12:01	-	12:30	0	0
29	12:31	-	13:00	0	0
30	13:01	-	13:30	0	0
31	13:31	-	14:00	0	0
32	14:01	-	14:30	0	0
33	14:31	-	15:00	0	0
34	15:01	-	15:30	0	0
35	15:31	-	16:00	0	0
36	16:01	-	16:30	0	0
37	16:31	-	17:00	0	0
38	17:01	-	17:30	0	0
39	17:31	-	18:00	0	0
40	18:01	-	18:30	0	0
41	18:31	-	19:00	0	0
42	19:01	-	19:30	0	0
43	19:31	-	20:00	0	0
44	20:01	-	20:30	0	0
45	20:31	-	21:00	0	0
46	21:01	-	21:30	0	0
47	21:31	-	22:00	0	0
48	22:01	-	22:30	0	0
49	22:31	-	23:00	0	0
50	23:01	-	23:30	0	0
51	23:31	-	0:00	0	0
52				0	0
EV

Cell Formulas
Range	Formula
AH4:AH51	AH4	=SUM((COUNTIFS($D$5:$D$50,">="&AE4,$D$5:$D$50,"<="&AG4))+(COUNTIFS($D$56:$D$105,">="&AE4,$D$56:$D$105,"<="&AG4))+(COUNTIFS($N$5:$N$50,">="&AE4,$N$5:$N$50,"<="&AG4))+(COUNTIFS($N$56:$N$105,">="&AE4,$N$56:$N$105,"<="&AG4))+(COUNTIFS($X$5:$X$50,">="&AE4,$X$5:$X$50,"<="&AG4))+(COUNTIFS($X$56:$X$105,">="&AE4,$X$56:$X$105,"<="&AG4)))
AI4:AI51	AI4	=SUM((COUNTIFS($F$5:$F$50,">="&AE4,$F$5:$F$50,"<="&AG4))+(COUNTIFS($F$56:$F$105,">="&AE4,$F$56:$F$105,"<="&AG4))+(COUNTIFS($P$5:$P$50,">="&AE4,$P$5:$P$50,"<="&AG4))+(COUNTIFS($P$56:$P$105,">="&AE4,$P$56:$P$105,"<="&AG4))+(COUNTIFS($Z$5:$Z$50,">="&AE4,$Z$5:$Z$50,"<="&AG4))+(COUNTIFS($Z$56:$Z$105,">="&AE4,$Z$56:$Z$105,"<="&AG4)))
AH52:AI52	AH52	=SUM(AH4:AH51)

However, because I have some lines on that page hidden, I end up with

Weekday Bus Cycling - Master - Copy.xlsm
	AE	AF	AG	AH	AI
4	0:01	-	0:30	0	0
5	0:31	-	1:00	0	0
6	1:01	-	1:30	0	0
7	1:31	-	2:00	0	0
8	2:01	-	2:30	0	0
9	2:31	-	3:00	0	0
10	3:01	-	3:30	1	0
11	3:31	-	4:00	2	0
12	4:01	-	4:30	1	0
13	4:31	-	5:00	1	0
14	5:01	-	5:30	0	0
15	5:31	-	6:00	2	0
16	6:01	-	6:30	1	0
51	23:31	-	0:00	0	2
52				21	12
Aberfoyle-MON-WED

Cell Formulas
Range	Formula
AH4:AH16,AH51	AH4	=SUM((COUNTIFS($D$5:$D$50,">="&AE4,$D$5:$D$50,"<="&AG4))+(COUNTIFS($D$56:$D$105,">="&AE4,$D$56:$D$105,"<="&AG4))+(COUNTIFS($N$5:$N$50,">="&AE4,$N$5:$N$50,"<="&AG4))+(COUNTIFS($N$56:$N$105,">="&AE4,$N$56:$N$105,"<="&AG4))+(COUNTIFS($X$5:$X$50,">="&AE4,$X$5:$X$50,"<="&AG4))+(COUNTIFS($X$56:$X$105,">="&AE4,$X$56:$X$105,"<="&AG4)))
AI4:AI16,AI51	AI4	=SUM((COUNTIFS($F$5:$F$50,">="&AE4,$F$5:$F$50,"<="&AG4))+(COUNTIFS($F$56:$F$105,">="&AE4,$F$56:$F$105,"<="&AG4))+(COUNTIFS($P$5:$P$50,">="&AE4,$P$5:$P$50,"<="&AG4))+(COUNTIFS($P$56:$P$105,">="&AE4,$P$56:$P$105,"<="&AG4))+(COUNTIFS($Z$5:$Z$50,">="&AE4,$Z$5:$Z$50,"<="&AG4))+(COUNTIFS($Z$56:$Z$105,">="&AE4,$Z$56:$Z$105,"<="&AG4)))
AH52:AI52	AH52	=SUM(AH4:AH51)

Is there a way around this issue, so that my chart wont hide with the rest of the page?

Thanks

 

[Jimmypop]

Hi there

Right click on chart... Format Chart Area... Go to Properties and make sure to select Don't move or size with cells... This should keep the chart and not hide it with the hidden cells...