+ Reply to Thread
Results 1 to 2 of 2

Really Need Help with Marked Line Chart/Plot

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010 for Mac
    Posts
    60

    Really Need Help with Marked Line Chart/Plot

    I am trying to put together a chart from a pivot table and I am not getting what I am looking for. I have attached a workbook with an idea of what I am trying to go for, and roughly what I have done so far.

    The Chart I want will have 3 series, but instead of just plotting one point for each series (like the sum total cost of that series for each X axis), it will instead plot the campus types associated with that series, so series A should have more than one plot point above each location, which I have for the X axis. Refer to the pivot table on the first tab for the idea of what I am trying to do.

    Hopefully this is clear.
    Attached Files Attached Files

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

    Re: Really Need Help with Marked Line Chart/Plot

    Try putting the Campus Type field in the Column Labels box along with Campus
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. plot every Nth value in Line Chart
    By twd000 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2010, 06:00 AM
  2. Line chart that does not plot zero values
    By TrolleyDude in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-25-2010, 07:08 AM
  3. Making a gap in a Chart Plot Line
    By steven723 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-06-2009, 07:29 AM
  4. [SOLVED] Getting a line chart to NOT plot a zero value
    By sheryl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-26-2005, 09:05 AM
  5. I want to draw a line through the columns of a chart, plot the o.
    By Dewey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2005, 08: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