+ Reply to Thread
Results 1 to 8 of 8

Pareto Chart, set line chart origin at zero

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    washington
    Posts
    24

    Pareto Chart, set line chart origin at zero

    I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart. Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart. I'm fairly new to VBA and not sure where to start. Any insight would be appreciated. Let me know if further clarification is needed.
    Last edited by VBA Noob; 12-03-2008 at 05:26 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    In order to get the line to start at 0,0 you would need to set the axis to Cross between categories.

    Perhaps the better option would be to use a xy-scatter chart type rather than line.

    If you need help with the chart post an example.
    Once the chart is correct we can worry about the code to create it.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Pareto Chart, set line chart origin at zero

    Not sure what you're asking for. Traditional Paretos plot the line
    from the upper right corner of the far left (largest) column.
    Would the Pareto Plotter example at Debra Dalgleish's website help?
    http://www.contextures.com/excelfiles.html#Charts

    Note: That file DOES contain macros...but, they're only for re-formatting the chart.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Registered User
    Join Date
    11-25-2008
    Location
    washington
    Posts
    24
    Attached is an example of the chart. Just trying to add a line from (0,0) to the 1st point on the line chart. Yes, I understand that a proper pareto doesn't begin at (0,0), but that's how the boss wants to see it unfortunately. Any help in aligning the points to the right of the bars would be appreciated as well. Thanks
    Attached Files Attached Files
    Last edited by ExcelFed; 11-28-2008 at 12:13 PM. Reason: Response to other comment

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    You will need to use xy-scatter rather than line chart type.

    Insert a row above you data for the 0,0 data pair.

    Right click chart and pick Chart Options. On the Axes tab enable the secondary X axis.
    You will also need to fix the secondary x axis at 0 to 10.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-25-2008
    Location
    washington
    Posts
    24
    This is close, but I can't have the minimum Y value show a negative number on the Primary Y axis and when I reset the scale to zero, the points on the line no longer align properly with the bar chart. Any other recommendations?

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    The Y axis displays -5 because of your fixed maximum value and the Major step.

    If you set the primary Y axis to have auto min/max scale values you should be alright.

  8. #8
    Registered User
    Join Date
    11-25-2008
    Location
    washington
    Posts
    24
    Thanks! Got it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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