Then you need to create a table, according to the numerical data of which we will build our diagram.
I never found a great solution.
Select the "Diagram layout"-tab and then Support lines and adds the ones you need.Circles can be deleted by clicking on the shape, and pressing the Delete key.Someone suggested to print an empty diagram in a big size and then laminate it with plastic to be able how to make a brain to enter the data on top of the basic diagram.However, we are a bit distracted.Now we can plot in the monthly stats and then erase it for each new month.If you have checked everything and were satisfied with the result, you can press the "Done" button.The crux of the matter is that scrolling text maker Excel adjust the diagram to your data.And I don't want to use a projector because this needs to be physical and tangible.Finally we now have a nice empty diagram that looks like this: What we did with this was to print it in 70x100 cm and laminated it in plastic.
That right there was the reason I started my blog, ca 900 posts ago.
If you right-click on the workspace, you can easily change the background, as well as correct the type of font you used.
Probably sets you back 4.
Note that the formatting tools in Excel are still far from perfect, so some "drove" values still have to be corrected.
But you can hide the line.Oh yeah, here's my workbook so you don't have to start from scratch.Its a little long so I had to break it up into multiple videos, but if your an excel zalando korting nieuwsbrief nerd like me, you will be glad you took the time.Complete the diagram by adding all of your text to the appropriate circles.And after ca 2 hours I felt the need to write this blog post.We also thought about putting it behind glass but decided against it because that would make it much more bulky.Open Excel (I'm using 2010 for Mac, in Swedish for some bisarr reason.The 200 in Threshold 2 will make sure the Y-axis goes to 200.Let's create an diagram like the one above; to track the number of customers per day and with two horizontal lines showing two important thresholds.