General discussion

  • Creator
    Topic
  • #2273392

    Creating Chart on Excel

    Locked

    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.

All Comments

  • Author
    Replies
    • #2727070

      Reply To: Creating Chart on Excel

      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.

    • #2724941

      Reply To: Creating Chart on Excel

      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.

    • #2699338

      Reply To: Creating Chart on Excel

      by Mark W. Kaelin ·

      In reply to Creating Chart on Excel

      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.

    • #2699225

      Reply To: Creating Chart on Excel

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

    • #2714068

      Reply To: Creating Chart on Excel

      by shaundyc ·

      In reply to Creating Chart on Excel

      This question was closed by the author

Viewing 4 reply threads