Hi, I've got data in 2 columns both giving me the times planes arrived and departed.
The data is structured like this:
Flight Departed HourDeparted Landed HourLanded
BA899 18:07 18 22:00 22
QF111 10:20 10 14:10 14
SQ300 11:32 11 16:55 16
RY710 0345 3 17:00 17
With dual axis, I could get a chart that is almost correct. Issues:
- the blue line is calculating wrongly though the orange is correct
- i want a stacked bar - so I can see its total.
For example, using the data in the graph, at
- 12 midnight, 787 planes departed; 60 landed. Total planes = 847
- at 1 am, there were 623 + 35 = 658 planes, etc...
Without custom sql and doing a "union", is there a way?
Message was edited by: Sea Urchin I thought the line graph was correct when I first posted, but now realise the blue line is counting incorrectly.