creating an excel chart

Posted on 2012-08-22
Last Modified: 2012-08-31
Hi I have attached an excel chart. I want to create the chart when I can get all the accounts together, all the mob together and all the economics together....not separated as you see it now....

can someone help me do this??? so in the different years you see how one subject did throughout and you do it for all those 3 subjects fir the years 2009-2012
Question by:slingingshot15
    LVL 11

    Expert Comment

    This is a little misleading.  When I look at the chart the year isn't lined up with the correct data.  I'll include 2009 through current.  So one extra set of bars.  I'll have your chart in just a minute.

    Author Comment

    ok thanks and please explain to me how u did it as well...thanks
    LVL 11

    Accepted Solution


    Here it is,
    you'll notice I did a little data reorg off to the side that I used for the combined bar chart.  

    It was just a lot more difficult in the format you had to get a chart to work by swapping axis.  

    I've linked it all so it should auto update.  

    Let me know if you have any questions.

    I included some other options as well.  


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now