Have you ever seen a line chart in Excel that’s suddenly dropping to zero? Here’s why it happens and what to do about it:
Let’s say you have a table where you enter new sales figures every day, and a line chart connected to it. The sales figures for the last few days in the table have not yet been filled out, so the last values for the y-axis are zero. This is what the line chart could look like:
In Excel you often want to copy the cell right above the active cell. Instead of the usual Copy-Paste routine, there is a keyboard shortcut in Excel which will make your life easier:
Ctrl + D
Other Shortcuts:
Is there an easy way to locate and highlight duplicates in a list in Excel?
If you just want to remove the duplicates, the easiest way is to use the Advanced Filter or the built-in Remove Duplicates feature on the Data ribbon, but what if you want to find the duplicates in the list, keep them and highlight them with a different colour? That almost sounds like a job for a professional Excel consultant, but there’s no need for that – you can easily do it yourself! I’ll show you one easy way and one super-easy way:
READ MOREIf you write something for a webpage, chances are that you write the text in HTML code. If you’re used to it, it often turns out to be easier than writing the text in a What-you-see-is-what-you-get-editor (WYSIWYG). In my experience, the WYSIWYG-editors never really work the way you want, so the HTML editor turns out to be better after all.
But what if you want to use a table that you have created in Excel? How can you transform an Excel table into a piece of HTML code that looks like this?
READ MOREWe often need to measure the length of a text, for example if we write a text that will appear on a website. Typically, in a web shop the product introduction text has to be of a certain length in order to fit within the frames.
Of course, the easiest way to do this is in Excel. This is extremely easy – it only takes a few seconds:
Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than they did before, but you still need to make a few changes if you want them to look good enough for a presentation.
These are the 5 things you can do to make your Excel chart look professional:
READ MORE