+ Reply to Thread
Results 1 to 3 of 3

Adding Cadence into a funnel graph

  1. #1
    Registered User
    Join Date
    03-02-2015
    Location
    Bristol, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    4

    Adding Cadence into a funnel graph

    Due to the excellent help i got earlier today, i'm going to try my luck again

    Can anyone product a graph that looks like the following image for me? (apologies for the HUGE image) :

    chart1.jpg

    I have a registration funnel for my website and want to show the time 'cadence' that it takes the average person to move between each stage. Can anyone help?

    Marketing funnel.xlsx

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Adding Cadence into a funnel graph

    Add two new series to the chart. Make them xy-scatter.
    Set the name, x and y values.
    Use arrow shape for marker. Copy then arrow then select marker and paste.
    Display series name in the data label.

    Format the secondary vertical axis to the number of bars in your bar chart.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-02-2015
    Location
    Bristol, England
    MS-Off Ver
    Office for Mac 2011
    Posts
    4

    Talking Re: Adding Cadence into a funnel graph

    That's BRILLIANT!

    Thank you so much for this. I continue to be amazed by what Excel can do

+ 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. Make Funnel/ Fall-off Graph
    By degross77 in forum Excel General
    Replies: 0
    Last Post: 05-04-2011, 05:56 PM
  2. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  3. [SOLVED] How do i create a funnel graph
    By charliew in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2006, 06:50 AM
  4. How do I create a sales funnel graph/chart with Excel?
    By CharlesJ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-24-2006, 05:15 PM
  5. [SOLVED] funnel chart
    By Pevans in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2005, 04:06 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