+ Reply to Thread
Results 1 to 3 of 3

Stacked bar chart problems. Creating 2 bars next to each other.

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    31

    Unhappy Stacked bar chart problems. Creating 2 bars next to each other.

    Hi all,
    I have a problem developing proper Bar chart.


    I would like to create chart where I would present results for 2 years + budget.
    I would like to use stacked bar chart for 2 years, where each year has got own bar divided in half: external works and internal works, whilist the budget would come as a line.

    So far I have developed such a graph:

    Chart.JPG

    Though I need those years to be shown as separate bars monthly.

    Anyone helpful?
    Attaching current status.

    Regards'
    ~Vito
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Stacked bar chart problems. Creating 2 bars next to each other.

    Please fallow this example:
    http://www.andypope.info/charts/stackside.htm
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    11-18-2013
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Stacked bar chart problems. Creating 2 bars next to each other.

    Took me some time to rework but fits perfectly!

    Thank you sir!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 3 Separate Stacked bars in 1 Chart
    By bglick in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-18-2013, 11:20 AM
  2. Help hiding zero value bars in stacked 3d bar chart
    By tuna666 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-17-2013, 07:12 AM
  3. How to chart 2 stacked bars per day?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-24-2009, 11:59 AM
  4. [SOLVED] Stacked bars in a gnatt chart
    By Gnatt in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 03:35 PM
  5. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1