Results 1 to 6 of 6

Added series not showing up on graph

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    31

    Smile Added series not showing up on graph

    I made my first secondary axis graph for plotting shipping percentages. I'm not sure if I approached it the best way, but I have run into some problems.

    To give you some background before we proceed, we basically have on-time, early, or late shipments (initial). However after root-cause analysis (getting to final), we find some shipments were not real, and some are assigned to causality for missed shipment, etc. (i.e. machine was down, or material not available). I want, by date, the initial and final stacked histograms side by side. Obviously a gap between dates is preferred for asthetics, etc.

    Now to my problem...As we have developed the processes there are new categories for causality for missed shipments. In my "StackedHistogram" tab in row 2, you'll see three columns I've added. I can see them as a unique series, have assigned the cells needed for that series, but for some reason they will not "stack" w/ the other data for that row. If you look at the graph, you'll see "Sub-contractor" on the correct date, as an orange triangle, but as mentioned before, isn't stacked.

    So, my question...how can I add new columns of data (series) to my graph (one located in stackedhistogram tab) and have them plot like the other series on that same row? For example, for 8/6. Initial data is in row 19, and final is in row 20. Again, for row 20 it captures only data from columns C-K, but avoids data from columns L-N.

    Help would be appreciated.
    Attached Files Attached Files

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