+ Reply to Thread
Results 1 to 3 of 3

Graph Categories Repeating

Hybrid View

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    63

    Graph Categories Repeating

    How do I stop the graph categories from repeating? See attachment for an example. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,391

    Re: Graph Categories Repeating

    There are many reasons why experienced users of spreadsheets recommend against using merged cells. What you have is the same text in column a and b, and you are using both column a and column b ( because they are merged). If you unmerge the cells and delete either column a or column b, then you will only get one category label. Or, you can unmerge the cells and select either column a or column b to be the vertical axis labels rather than both columns. Or something similar to either.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    07-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Graph Categories Repeating

    That did it! Thank you!

+ 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. How to make line graph with categories on Y-axis
    By ITPro in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-28-2014, 01:14 PM
  2. Replies: 0
    Last Post: 09-13-2013, 10:13 AM
  3. Color coding in bar graph by categories
    By ajang in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2012, 06:18 PM
  4. Replies: 2
    Last Post: 10-28-2010, 03:49 PM
  5. Graph a BUNCH of Categories
    By hutch@edge.net in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 02-11-2009, 09:45 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