Results 1 to 8 of 8

PivotChart broken lines

Threaded View

bruiser PivotChart broken lines 11-01-2010, 05:31 PM
MarvinP Re: PivotChart broken lines 11-01-2010, 05:41 PM
bruiser Re: PivotChart broken lines 11-01-2010, 05:50 PM
MarvinP Re: PivotChart broken lines 11-01-2010, 06:31 PM
bruiser Re: PivotChart broken lines 11-01-2010, 06:44 PM
teylyn Re: PivotChart broken lines 11-01-2010, 06:54 PM
teylyn Re: PivotChart broken lines 11-01-2010, 06:59 PM
bruiser Re: PivotChart broken lines 11-01-2010, 07:09 PM
  1. #1
    Registered User
    Join Date
    11-01-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    19

    PivotChart broken lines

    I have a PivotChart where the data comes from a large tables of rows, organized as a sort of database.

    I'm trying to organize the PivotChart according to the following rules:

    1) There should be one line on the chart, and one legend entry, for each unique value of field "Rank".
    2) The X-axis should correspond to a field named "Rating".
    3) The Y-axis should correspond to a field named "Score".

    I have this working almost perfectly, except for a slight problem - For every possible unique value of the X-Axis, there is often one or more of the "ranks" (lines) that does not have a datapoint for that rating value. This results in the line breaking. It will connect two adjacent markers on the chart as long as, for a single line, that line has datapoints at both values. But whenever there is a gap, it just stops the line.

    Is there a way to get it to always connect adjacent markers? I've attached a picture demonstrating the problem.

    I want all the green triangles to always be connected, all the blue diamonds to always be connected, and all the red squares to always be connected.

    Is this possible?
    Attached Images Attached Images
    Last edited by bruiser; 11-01-2010 at 07:10 PM.

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