questforexcel
Board Regular
- Joined
- Jan 18, 2019
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
Hi All,
I am looking to showcase the net movement in each month of the year. I tried using combination of charts, cluster, stacked or line. But due to the different in size/scale of data points they were not visually showcasing the complete picture.
I was thinking of trying to do a waterfall for each of the months? Would that be better in any ways. Could you guide on any other alternative ways to show / highlight variance with smaller numbers over a larger base number across each of the 12 months.
Thank you,
I am looking to showcase the net movement in each month of the year. I tried using combination of charts, cluster, stacked or line. But due to the different in size/scale of data points they were not visually showcasing the complete picture.
I was thinking of trying to do a waterfall for each of the months? Would that be better in any ways. Could you guide on any other alternative ways to show / highlight variance with smaller numbers over a larger base number across each of the 12 months.
Thank you,
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | |||
4 | Type | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | ||
5 | Initial no. of devices | 1000 | 990 | 981 | 973 | 966 | 960 | 955 | 951 | 948 | 946 | ||
6 | Removed | -15 | -15 | -15 | -15 | -15 | -15 | -15 | -15 | -15 | -15 | ||
7 | new installs | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | ||
8 | Net no. of devices | 990 | 981 | 973 | 966 | 960 | 955 | 951 | 948 | 946 | 945 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F5:N5 | F5 | =E8 |
E8:N8 | E8 | =SUM(E5:E7) |