+ Reply to Thread
Results 1 to 3 of 3

Problems creating bar graph to show data clearly

  1. #1
    Registered User
    Join Date
    11-19-2020
    Location
    Trinidad
    MS-Off Ver
    MS Officd 2016
    Posts
    2

    Problems creating bar graph to show data clearly

    Hi All,

    I am trying to create a bar graph that highlights the goods that are being stolen to highlight the issue with the port police and customs. I am extremely rusty with excel and am having and issue creating a good bar graph. I am sure the issue is how I have created my data set. Ideally I would like each bar to be split in 3 to show Sent, Received and stolen for each day.
    Please see attached and offer suggestions.

    Warm regards,
    Attached Files Attached Files
    Last edited by BSFOODSVC; 11-20-2020 at 06:47 AM. Reason: Solved

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Problems creating bar graph to show data clearly

    If you change the layout of your data you can use a pivot table/chart to get required output
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-19-2020
    Location
    Trinidad
    MS-Off Ver
    MS Officd 2016
    Posts
    2

    Re: Problems creating bar graph to show data clearly

    Thanks Andy Pope. Your sample file helped tremendously. Cheers.

+ 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. [SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  2. [SOLVED] How to I make 1 000 look like 1000, problems creating scatter graph
    By tigergutt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2013, 08:11 AM
  3. Replies: 0
    Last Post: 05-10-2012, 06:56 PM
  4. Problems creating a graph
    By masond3 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-17-2011, 07:33 PM
  5. how to best show data on graph?
    By step_one in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-17-2011, 12:10 AM
  6. Having problems creating a graph
    By cmf0106 in forum Excel General
    Replies: 5
    Last Post: 09-02-2009, 08:08 PM
  7. [SOLVED] Scatter Graph - Data Label Problems
    By TBD in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 02:06 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