+ Reply to Thread
Results 1 to 4 of 4

Chart data and layout issues

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Chart data and layout issues

    Hi, I am new to excel, and learning as I go. After watching several videos and guides I am stumped on how to get the worksheet below to transition into a 100% stacked bar graph, preferably with x and y axis data reversed, if possible. The formatting always comes out scrambled and I have tried typing it out into excel as is, straight across, etc and do not know how the heck to get it to accurately show categories of Date, income, expenses and planned and actual amounts for income and expenses. Even when doing this with just a default chart data will not show or is all jumbled. Any advice on how to do this would be greatly appreciated!



    budget worksheet.jpg

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    O365 (PC) V 2210
    Posts
    35,718

    Re: Chart data and layout issues

    Here's somethin for you to start with. It would have been easier if you had attached a spreadsheet, rather thanan image (remember that for next time). This will get you started.

    You can (of course) hide the text in "Chart" if you don't want to see it.
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Chart data and layout issues

    I filled out both ways I did it before, and did a sample with your format. Your format seems to solve a lot of issues. Now I am just wondering how I could get the chart to show which bars represent income and expenses. The date too such as month and year is giving me a lot of pain as you see from my other attempts at this. I only need the chart to show the date one time on the chart. Also, I do not know why Excel does not like the original layout from the picture but if there is a way to use that layout to make this chart I am very interested in knowing. Thank you for your help Glenn.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Chart data and layout issues

    Not sure why graph will not show both income and expenses planned and actual budget on same graph will on separate graphs though. Anyone have ideas?

+ 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. Organizing Data Table in a Bar Chart Layout 5
    By dco223 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-03-2014, 09:57 AM
  2. need help changing data layout or adjust line chart properties to swap X/Y axis.
    By justinhampton81 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-25-2013, 05:47 PM
  3. data layout for a stacked bar chart
    By lwilson21 in forum Excel General
    Replies: 5
    Last Post: 06-16-2011, 04:31 AM
  4. Convert data from column layout to row layout
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 03:28 PM
  5. Layout Issues - Toolbars vs. Ribbons
    By CBFenton in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-28-2006, 10:15 PM

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