General discussion

Locked

Creating Chart on Excel

By shaundyc ·
Hello,

I have 9 columns on excel, say columns A1,A2,A3,B1,B2,B3,C1,C2,C3 - heres the scenario, I want to create a bar chart that displays the amount of A1,A2,A3 but the amount of A2 and A3 should be sum up. Its like I have a separate bar for A1 and a separete bar for A2+A3. Same goes with B1, B2+B3 and C1, C2+C3, this should be showed in 1 chart only. Right now Im having a hard time doing it so what I opted to do is to separate the chart for A1 and A2+A3.......

Any help is very much appreciated.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by gill_potter In reply to 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.

Collapse -

by shaundyc In reply to

Poster rated this answer.

Collapse -

by shaundyc In reply to Creating Chart on Excel

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.

Collapse -

by Mark W. Kaelin Editor In reply to Creating Chart on Excel

Well, tion-thee 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.

Collapse -

by shaundyc In reply to

Poster rated this answer.

Collapse -

by shaundyc In reply to Creating Chart on Excel

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..

Collapse -

by shaundyc In reply to Creating Chart on Excel

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums