If I don’t write this down I will forget it before the end of the day. That right there was the reason I started my blog, ca 900 posts ago.


Now... that require some formatting:
First let's add some extra helper lines that will prove useful when this
is a big, on the wall diagram.
- Select the "Diagram layout"-tab and then Support lines and adds the
ones you need.
- I added support lines for sub-scale for both X and Y axis
Secondly let's add some nice text for the axis
- Again select the "Diagram layout"-tab and choose Axis headings.
- Now you can add labels for the axis
While we're at it, let's add a Diagram heading (Diagram layout-tab, then
Diagram heading)
Once that is done you might have something that looks like this:
Now, let's make this an empty diagram, by not removing but hiding the
"Number of customers" line. If you remove the line... the diagram
collapses or expands depending on where you thresholds are set.
But you can hide the line. Here's how:
- Right click on the line and select "Format data series..."
- Select "Line" and then "Color"
- Now in the drop down for color you can select No line, which hides
it
- This leaves you with the line (that is now hidden) selected which
might look a bit strange. But just click the diagram and you'll see
the whole line go away.
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. Now we can plot in the monthly stats and then erase it for each
new month. We also thought about putting it behind glass but decided
against it because that would make it much more bulky.
**UPDATED:**
I got a question about the actual printing. I would advise against
printing this on several sheets of paper and taping or gluing them
together. It will not be straight and probably will mess up your drawing
a bit, in my experience.
Instead, go to a copy shop and ask them to do this for you. Probably
sets you back $4 or so. Well worth it I think. If you're Sweden go to
Arkitektkopia -
they are great. And if you in Södertälje
go to this office and you'll get awesome treatment
too. Mention my name for a cup of coffee. I'm good for it (my first
job!)
I know that I will find this useful later. I hope that you will too.
Oh yeah,
here's my workbook so you don't have to start from
scratch.

