Results 1 to 3 of 3

Thread: complicated problem...simple solutions?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    complicated problem...simple solutions?

    I am trying to create a workbook with some customizable graphs. I have followed this wonderful article (google "Excel Dynamic Named Ranges = Never Manually Updating Your Charts") so far. But my data is a little more complex and I am now stuck. My data is the daily sales of 14 locations. I want to filter it (i.e. choose just one location from the 14) before I graph it. How do i do that?

    (In the attached file PK is a primary key, not really useful when it comes to graphing. Location is the locations ID number. ccTotal, q87 and q91 are the sale values I am logging. One of these sales values is sufficient per graph)

    My final ambition is to be able to compare the locations sale over time on one graph. Is that possible?

    thanks very much!
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts