+ Reply to Thread
Results 1 to 9 of 9

Split column chart by Subject

  1. #1
    Registered User
    Join Date
    07-15-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    4

    Split column chart by Subject

    Hi,

    Please can anyone help me how to split the column chart by subject . I've attached the screenshot , example: it shows both history and biology subjects data in one column chart but I want them in two different column charts.

    Many thanks for your help.

    Thank you,
    Sindhu

    column.PNG

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,230

    Re: Split column chart by Subject

    It's very hard to be specific with just a picture. If that's a pivot chart, then you can't unless you create separate pivot tables for each subject. If it's a regular chart, just change the data source.
    Rory

  3. #3
    Registered User
    Join Date
    07-15-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    4

    Re: Split column chart by Subject

    Hi Rory,

    What should I change the data source to?

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,230

    Re: Split column chart by Subject

    To just the cells with the data you want displayed.

  5. #5
    Registered User
    Join Date
    07-15-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    4

    Re: Split column chart by Subject

    Thank you but I've already done that, need help in something that can be done dynamically instead of choosing the data every time for each column chart.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,230

    Re: Split column chart by Subject

    If you have multiple charts, you have to specify the data for each (whether that's manually or in code). If you have one chart, you can use formulas to determine which data to display. Either way, with the lack of information provided so far, it is pretty much impossible to be more specific.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,567

    Re: Split column chart by Subject

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new I will do it for you today: https://chandoo.org/forum/threads/sp...subject.46608/.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  8. #8
    Registered User
    Join Date
    07-15-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    4

    Re: Split column chart by Subject

    Thank you Admin

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,068

    Re: Split column chart by Subject

    Instructions for uploading a sample Excel file are given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK:" banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Split Subject in Folder and Subfolder
    By tiger19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2020, 03:38 AM
  2. Replies: 17
    Last Post: 01-12-2018, 12:57 PM
  3. [SOLVED] Help comparing two files by subject+Date, subject+DatePlus1, Subject+DateMinus1
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-11-2017, 07:37 AM
  4. Replies: 4
    Last Post: 11-30-2015, 05:06 PM
  5. Macro for Exporting Outlook Messages to Excel - Split Subject problems
    By jbeans in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-04-2013, 08:29 PM
  6. Replies: 5
    Last Post: 05-10-2010, 09:49 AM
  7. Replies: 3
    Last Post: 08-07-2009, 12:03 PM

Tags for this Thread

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