+ Reply to Thread
Results 1 to 3 of 3

line chart formatting problem

  1. #1
    Registered User
    Join Date
    06-01-2012
    Location
    Swarthmore, PA, USA
    MS-Off Ver
    Excel:mac 2011
    Posts
    14

    line chart formatting problem

    Hello all,

    For work I am creating a bar graph with four sets of data (i.e.---four bars for each discrete x-axis value). These four sets of data are all supposed to conform to the same max limit. I'd like to graph this limit as a line and not a set of columns or bars. I need the limit to be a line with a positive slope before it goes constant for a bit and then jumps to a higher constant for the remainder of my relevant x values.

    Doing this as a line chart can't give me the jump discontinuity that I'm looking for. Doing it as a scatter plot doesn't seem to work with my discrete, logarithmic x-axis. I can't really just draw the lines on either as I have to define the numerical limit very accurately. Could I maybe do it point by point graphing the individual points as horizontal bars? I am currently searching for a way to do that. Any help would be much appreciated.

    Thanks in advance,
    Noah

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

    Re: line chart formatting problem

    post example workbook of you current data layout and chart. Draw the required line so we can understand exactly what you are trying to achieve.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-01-2012
    Location
    Swarthmore, PA, USA
    MS-Off Ver
    Excel:mac 2011
    Posts
    14

    Re: line chart formatting problem

    I am unable to post the workbook or an attachment because of the NDA's I've signed (sorry). Anyways I came up with a basic, temporarily acceptable fix where I still use a line chart but hide the line and use the markers to show the limit. It doesn't give me the line I want but the limit is clearly defined and visible which is most important to me.

    Thanks,
    Noah

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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