+ Reply to Thread
Results 1 to 5 of 5

Graphing with a column and line graph on one graph

  1. #1
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Graphing with a column and line graph on one graph

    Hi

    I have two results I want to graph in one graph and I think the best way to show this could be one result displaying as a column graph and the other as a line graph. I am open to any other ideas to present these results in a different graph set up.

    The results I am graphing is a star rating system, basically a 1 to 5 star result(first data set) is given depending on performance. The star result assigned is determined by what star %(second data set) is achieved.

    For example a 1 star is achieved by receiving a star % below -50%, a 2 star is achieved by receiving a star % of -21% to -49%, a three star is achieved by receiving a star % of -20% to 20%, a 4 star is 21% to 39% and 5 star is above 40%

    See attachment for the numbers I am looking to graph.

    Thank Data to graph.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Graphing with a column and line graph on one graph

    Hi there. Something like this, maybe?
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Graphing with a column and line graph on one graph

    Thanks Glen

    That is what I am looking for but I have no idea how to set this up in my own report, I'm not sure how to have a primary and secondary axis.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Graphing with a column and line graph on one graph

    For some reason, I cannot post the instructions on the site. I get a security rejection message. Others have experienced the same problem on this site in recent days. Send me your email address by PM and I will return a step-by-step guide.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Graphing with a column and line graph on one graph

    Please see the PM that i snet you. There's a problem on the Forum site that somethimes blocks us from posting replies. I need your email adress to return a guide. Send it to me by PM.

+ 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. Graphing seasonal performance (line graph)
    By oifla in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2013, 02:23 PM
  2. Graphing seasonal performance (line graph)
    By oifla in forum Access Tables & Databases
    Replies: 0
    Last Post: 10-08-2013, 02:03 PM
  3. [SOLVED] Graphing a column graph within a line graph
    By NeoFlex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-16-2013, 08:23 AM
  4. Add secondary column graph to existing line graph
    By nbuk in forum Excel General
    Replies: 8
    Last Post: 09-02-2010, 11:49 AM
  5. How to combine one segmented column graph with line graph in one chart
    By hamood83 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2007, 03:19 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