Save your favourite chart settings As I wrote in a previous post, the default charts in Excel don’t look very nice, and I described how you can make a column chart look great in just a few minutes. If you find yourself doing the same amendments every time you make a chart, it might be … Continue reading
Filed under Charts …
Excel Line Chart: How to prevent the line from dropping to zero
A new version of this article has been published here: http://easy-excel.com/?p=526 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 six values for the … Continue reading
Create a Dynamic Chart in Excel in 5 minutes
A new version of this post has been published here: http://easy-excel.com/?p=604 In this post I will show how to create a dynamic chart in Excel, ie. a chart that updates automatically. In many situations you collect data every day (sales figures, stock prices etc.) for months and years, but you only want to show the … Continue reading
How to make Excel charts look more professional in 2 minutes
A new version of this post has been published here: http://easy-excel.com/?p=404 Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than in, say Excel 2003, but you still need to make a few changes if you want them to look professional. These are the 5 … Continue reading