+ Reply to Thread
Results 1 to 2 of 2

Graph not showing months ?

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Graph not showing months ?

    Hi i am trying to pull together a graphs that will show data for the year, i have attached my data for jan,feb

    i want to be able to show several graphs for the year, i managed to show graph for Total worked % but when i try to create new graph for any of the other data it does not show me the months and shows up as the number 1 and 2

    please see attached - what am i doing wrong


    Dougers1
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Graph not showing months ?

    if you goto the data > Select data
    you will see you sre using
    =(Sheet1!$B$1:$B$2,Sheet1!$G$1:$G$2)
    for the x-axis - which shows Jan/Feb

    On the number graph
    just edit the data and use
    =(Sheet1!$B$1:$B$2,Sheet1!$G$1:$G$2)

    Select Data>
    Horizontal Data
    Edit

    see attached
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. X axis in X,Y scatter graph showing duplicate months
    By mtndewgradon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-07-2013, 07:23 AM
  2. Subtracting Dates and showing the answer in months
    By mitch1976 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2013, 02:57 PM
  3. Showing only active months in chart data
    By amartino44 in forum Excel General
    Replies: 4
    Last Post: 02-05-2013, 05:51 PM
  4. Charts: Only showing months with data
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-05-2013, 03:53 PM
  5. Excel 2007 : Showing negative months
    By hpasso217 in forum Excel General
    Replies: 1
    Last Post: 03-04-2011, 06:20 PM
  6. Pivot Table - Showing Months
    By misty0705 in forum Excel General
    Replies: 3
    Last Post: 07-08-2008, 02:09 AM
  7. [SOLVED] Graph Help- 12 month graph, but only want months that have passed
    By coal_miner in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-03-2005, 11:05 AM

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