Creating Chart on Excel

The quick way is to create a new row A4 that is a sum of A2 and A3. Then select just the 1 row and ctrl select the 4 row and click the chart wizard. This will create a bar chart that has the A1value next to the A4 value and then the next bucket will be the B1 value compared to the B4 value. If you want to compare all of the 1 values together and all of the 4 values together just change the chart option to data in columns rather then data in rows.

I already thought of that, but what i like is to make it cumulative say every month the amount of the previous month will be added to the present. and i want it to be easily visible so it has to be in different color. I have a prob also that it seems all the bar are added together, it wont show a 2 bar graph on each month.

Well, [b]tion-thee[/b] if you merely want the bar graph to show A2+A3 as one value (color), you could just edit the properties for those series to be the same color with no lines separating them. To the viewer it will look like the value of A2 is added to the value of A3 for a total.

Now, if I read your comment right you would like to take this a step further and have a running cumulative total that displays in graphical form each month. That is an interesting question that could apply to many TechRepublic members ? I'll write up an article on it and make a sample Excel spreadsheet available for download. Give me a week of so to get it all together.

Thanks for the question.

Thanks MKaelin, that would be great! I'll just wait for it then. Hey, if not to much to ask can you inform me once the sample spreadsheet is out there for download..

This question was closed by the author