+ Reply to Thread
Results 1 to 2 of 2

Categories option not available in combination chart

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2013
    Posts
    1

    Categories option not available in combination chart

    I want to be able to select certain weeks instead of having the chart run Week 1 to 52. However, the categories option in the filter menu is not there. Is there a way to fix this?

    Categories.jpg

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: Categories option not available in combination chart

    You can't in standard chart using Excel range/table as data source/range. Using filter option, you can only add or remove series (i.e. not axis values).

    You could use pivot table to summarize data and use pivot chart. It will give you option to filter on axis values (categorical or linear type).

    Alternately, you could use formula and named range to create dynamic range to supply to the chart, or create intermediate table using formula to feed data to the chart.
    Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.
    ― Robert A. Heinlein

+ 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. Chart from Categories with Sub-Categories
    By Chris Nolen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-06-2017, 09:49 AM
  2. Replies: 1
    Last Post: 06-23-2016, 08:36 AM
  3. Option Box, Julian Date & Text Box Combination
    By irsan anwar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2015, 08:43 PM
  4. [SOLVED] Add line chart to bar chart with multiple categories
    By EthanM in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2014, 04:12 PM
  5. Chart Categories
    By flavordave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-25-2009, 09:25 PM
  6. [SOLVED] Chart Categories
    By SJT in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 03:20 PM
  7. 3D chart categories
    By elementary in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-22-2006, 01:59 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