This column chart shows daily, weekly or monthly data depending on the user's choice. In daily the columns are displayed properly, but in weekly & monthly mode the columns are a fraction of the width they should be - why, and how can this be...
Topics: axis formatting, bar charts, charting, Charts and Graphs, date axis, dynamic charts, homework, Learn Excel, reader questions, user polls

{"title":"Fix this chart [excel homework #1]","post_url":"http:\/\/chandoo.org\/wp\/2009\/06\/30\/fix-chart-axis-formatting\/","feed_url":"http:\/\/chandoo.org\/wp\/feed\/","author":"chandoo","date":"2009-06-30 02:00:02","summary":"This column chart shows daily, weekly or monthly data depending on the user's choice. In daily the columns are displayed properly, but in weekly & monthly mode the columns are a fraction of the width they should be - why, and how can this be..."}

Here is a quick formula trick you can use to generate sequence numbers that only increment when there is a change.Assuming the sequence of values are in column C from C3, you can write the following formula in B4 onwards (B3 will be 1, wake...
Topics: Analytics, Excel Howtos, Learn Excel, microsoft, Microsoft Excel Functions - Examples & Tutorials, numbers, spreadsheet, spreadsheets, tips, tricks, tutorial, unique

{"title":"Create a number sequence for each change in a column in excel [Quick Tip]","post_url":"http:\/\/chandoo.org\/wp\/2009\/06\/29\/generate-sequence-numbers\/","feed_url":"http:\/\/chandoo.org\/wp\/feed\/","author":"chandoo","date":"2009-06-29 03:00:46","summary":"Here is a quick formula trick you can use to generate sequence numbers that only increment when there is a change.Assuming the sequence of values are in column C from C3, you can write the following formula in B4 onwards (B3 will be 1, wake..."}

In today's installment of project management using excel, we will learn about project tracking tool - to-do lists. Projects are nothing but a group of people getting together and achieving an objective – like building system or constructing a...
Topics: circular formulas, downloads, excel apps, free, Google Spreadsheets - Tip & Tricks, Learn Excel, microsoft, Microsoft Excel Functions - Examples & Tutorials, screencasts, sharing workbooks, spreadsheets, to do list with excel, tutorials

{"title":"Team To Do Lists - Project Tracking Tools using Excel [Part 2 of 6]","post_url":"http:\/\/chandoo.org\/wp\/2009\/06\/25\/todo-lists-project-tracking-tools\/","feed_url":"http:\/\/chandoo.org\/wp\/feed\/","author":"chandoo","date":"2009-06-25 03:00:34","summary":"In today's installment of project management using excel, we will learn about project tracking tool - to-do lists. Projects are nothing but a group of people getting together and achieving an objective \u2013 like building system or constructing a..."}

In this edition of Excel Links, we feature a new excel blog on the blog, named bacon bits. We also share links about interesting articles like generating tinyurls using vba, making maps using xy charts, designing filters for your dashboards and more.
Topics: dashboards, data filters, excel links, macros, maps, scatter charts, VBA, VBA Macros, visualizations

{"title":"Excel Links - Bacon bits are good edition","post_url":"http:\/\/chandoo.org\/wp\/2009\/06\/23\/excel-links-bacon-edition\/","feed_url":"http:\/\/chandoo.org\/wp\/feed\/","author":"chandoo","date":"2009-06-23 03:00:26","summary":"In this edition of Excel Links, we feature a new excel blog on the blog, named bacon bits. We also share links about interesting articles like generating tinyurls using vba, making maps using xy charts, designing filters for your dashboards and more."}

It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list / table. To remove duplicates, (1) Just select the list of...
Topics: 15sectuts, excel 2007, Excel Howtos, remove duplicates, ribbon, screencasts, unique items, videos

{"title":"Remove Duplicates [Quick Video Tip]","post_url":"http:\/\/chandoo.org\/wp\/2009\/06\/22\/remove-duplicates\/","feed_url":"http:\/\/chandoo.org\/wp\/feed\/","author":"chandoo","date":"2009-06-22 03:00:41","summary":"It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list \/ table. To remove duplicates, (1) Just select the list of..."}