+ Reply to Thread
Results 1 to 3 of 3

Creating a graph with dates in the x and two possible text values per a date in the y

  1. #1
    Registered User
    Join Date
    08-17-2020
    Location
    Jerusalem, Israel
    MS-Off Ver
    Microsoft for Business 365 64-bit
    Posts
    2

    Creating a graph with dates in the x and two possible text values per a date in the y

    I want to create a chart on excel.

    The x-axis is time.

    For the y-axis I have two text values, B2C and B2B. Each text value may appear once or more per a date.

    I want to graph two lines, one for each text value, based on how many times they appear per a date. So for example one data point for the B2B line might be [2/3/2020, 3] because there were 3 B2B values on 2/3/2020.

    Here is an example of some of the values:

    25/11/2019 B2C
    04/03/2020 B2C
    10/06/2020 B2C
    26/02/2020 B2B
    26/02/2020 B2B
    10/02/2020 B2B
    17/02/2020 B2B
    13/03/2020 B2B

    Can someone please help me with this?

    Thank you

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,373

    Re: Creating a graph with dates in the x and two possible text values per a date in the y

    See attached file.
    I wrote your sample data in a table (columns A:B)
    Then created pivot table out of the data (columns F:H)
    And eventually made bar graph out of the pivot table (columns J...)
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    08-17-2020
    Location
    Jerusalem, Israel
    MS-Off Ver
    Microsoft for Business 365 64-bit
    Posts
    2

    Re: Creating a graph with dates in the x and two possible text values per a date in the y

    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. [SOLVED] Convert Text Dates to Date Values
    By mycon73 in forum Excel General
    Replies: 10
    Last Post: 02-15-2020, 03:00 PM
  2. Creating a graph with only positive numbers from 2 dates
    By bzbysenski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2019, 03:53 AM
  3. [SOLVED] Dates stored as Text and Values - convert entire column to date?
    By happydays886 in forum Excel General
    Replies: 12
    Last Post: 01-05-2018, 12:13 PM
  4. Creating a Scatter or Line Graph Using a Wide Range of Dates
    By awebster in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-23-2016, 12:10 PM
  5. [SOLVED] Creating line graph of dates for four years
    By wagstaffjh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2014, 06:23 PM
  6. Replies: 0
    Last Post: 05-10-2012, 06:56 PM
  7. Creating a graph from text
    By lordterrin in forum Excel General
    Replies: 5
    Last Post: 10-18-2010, 06:15 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