Create stacked Bar Chart

Posted on 2011-10-12
Last Modified: 2012-05-12
looking for information on how to create a stacked bar chart, i have been googlein but can not for life of me find a good page that talks about how to create a stacked bar chart from making data to presentation.  I can get the data its the spresentation part.  The following is my data counts

Total            Final               Initial         FNONDep       FDep            INONDEp           IDEP
255      141      114      53      88      48      66

So teh total is for the side Axis, then I need to create stacked bar charts of hte Final versus Initial   So the stacked chart needs to be the FNONDEp and FDEp cobine in chart to make FINAL and same for INONDEP and IDEP.  My problem is each time I add a number to chart it keeps making it same bar, how do i seperate them or craete different series.
Question by:kdeutsch
    LVL 39

    Accepted Solution


    Would try this:

    select total, final num, 'final' val into #temp
    insert into #temp select total, initial,'initial' val
    select * from #temp

    that will create your correct dataset.

    Then your series becomes num, and your group is val.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now