+ Reply to Thread
Results 1 to 1 of 1

Conditional Formatting Charts with follow-up data

  1. #1
    Registered User
    Join Date
    04-12-2008
    Location
    SF BAY Area
    Posts
    32

    Conditional Formatting Charts with follow-up data

    I have a stacked bar chart for each day of the month that totals the quantity of four different types of scheduled sales orders per day (Truck, Ship, Rail, Export).

    Is there anyway to add a completion tag or pattern to each individual task/unit on the chart if there is a corresponding "completion" column added to the spreadsheet?

    Currently, I am using a pivot table to generate the chart.

    The goal is to display the loading and types of orders scheduled each day when looking forward and to mark off/display the completed orders when looking back.

    At this point, I have been able create two bars side by side on the pivot chart for each date, that totalizes the loading count and "completed" count.

    Any interesting options to try?
    Attached Files Attached Files
    Last edited by Drew Goldberg; 08-16-2010 at 04:49 PM. Reason: Added Sample workbook

+ 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