+ Reply to Thread
Results 1 to 3 of 3

How to create a bar graph based on specific columns?

  1. #1
    Forum Contributor
    Join Date
    01-01-2022
    Location
    India
    MS-Off Ver
    Home 2021
    Posts
    778

    How to create a bar graph based on specific columns?

    Hi all,

    Hope all is well.

    In the attached file, i want the graph to show Open, Created and Closed request and incidents based on Date and not based on month?

    I tried but all in vain. Can someone please help with the solution?

    Thanks in advance.
    Last edited by rizwanulhasan; 02-27-2023 at 04:53 AM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: How to create a bar graph based on specific columns?

    Right click on graph, click select data, change axis labels, click edit, change range ='Ticket Count'!$A$4:$A$264 to ='Ticket Count'!$B$4:$B$264
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor
    Join Date
    01-01-2022
    Location
    India
    MS-Off Ver
    Home 2021
    Posts
    778

    Re: How to create a bar graph based on specific columns?

    Thanks a ton avk .

+ 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] How to create a dynamic graph with check boxes to choose a specific year?
    By gauger111 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-22-2018, 02:06 AM
  2. Create a graph based on item ID
    By peels2141 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-25-2013, 08:50 AM
  3. How to create a graph from 2 different columns
    By ExcelVBANoobie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 01:22 PM
  4. Trying to create VBA code to change the scale of the x value on a specific graph
    By poindexter1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 06:45 AM
  5. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  6. macor to create chart/graph for a specific row of data
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2006, 04:20 PM
  7. Can I create graph combining clusted and stacked columns?
    By Robin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2006, 11:35 AM

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