Two most commonly asked or searched queries when it comes to charting are,

• How to combine two chart types in one chart, like a line chart combined with bar chart?
• How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?

Watch this video tutorial to learn how to do both in less than 15 seconds.

Watch it on youtube: Creating combination charts and adding secondary axis - video tutorial

I am very happy to share this exciting news with you. June, 2009 has been the best month ever since I started this blog. We have received 239,000+ page views from 95,000+ visitors and our community had 800 new members. We now have 4,300+ of you have signed up for our RSS feeds and e-mail news letters. Read the post to find out more.

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 avoided? Bonus points if you can describe how to use an INDIRECT formula on the x-axis labels which is another problem. Go fix it.

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 up…)
=IF(C4=C3,B3,B3+1)
Now just copy paste the formula over the entire range [...]

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 bridge. While it is important to have a overall project plan and vision, it is equally important to understand how various day to day project activities are going on. This is where to do lists can help you a lot. Read on…

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 values from which you want to remove duplicates (2) Go to Data ribbon (3) Hit the Remove Duplicates button (4) Bingo…