mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Guys,
I have a some data that is tracked on a weekly basis, I have created a bar chart to show what the figure is on each day.
Now there could be some random days where the figure is really high so that shows all the other values as really small and bar charts shrink and therefore cant see trends..
My manager wants me to either show the abnormal values as 0 and have a comment somewhere or do some other technique that ensures all data can be visually viewable and be anle to spot trends...
So what is the best way to do it and how shall i do
it.
If someone can come up with something that would be awesome..
I have a some data that is tracked on a weekly basis, I have created a bar chart to show what the figure is on each day.
Now there could be some random days where the figure is really high so that shows all the other values as really small and bar charts shrink and therefore cant see trends..
My manager wants me to either show the abnormal values as 0 and have a comment somewhere or do some other technique that ensures all data can be visually viewable and be anle to spot trends...
So what is the best way to do it and how shall i do
it.
If someone can come up with something that would be awesome..