In this example, we’ll make our line increase by 5.27% each year. You need to fill in some placeholder numbers with estimated values. So how did I do this? How to Add Placeholder Data to Your Table Dotted lines are great for visualizing estimates or uncertainty. We used a dotted line to connect two points on the graph. ![]() Nothing.Īnd, there’s all this white space between FY07 and FY17, which is obviously not going to work. Second, what if your dates don’t go in order? What if you’ve got data for one point in time… and then you skip a big chunk in the middle?įirst, I tried filling in my table with the few data points that were available.Įxcel doesn’t quite know what to do with that.Įxcel didn’t show anything at all for FY07.First, how do you take your bullet points and transform them into a graph? What type of graph should it be? How should it be formatted? How do you make the graph easy to understand?. ![]() Here’s a common data visualization challenge: Slides with some, but not all, of the chronological data included.
0 Comments
Leave a Reply. |