+ Reply to Thread
Results 1 to 1 of 1

Creat charts data table on VBA with condition apply

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003, 2010
    Posts
    21

    Creat charts data table on VBA with condition apply

    Hi everyone,

    Here i am with completely new problem on VBA:
    Attachment 263186

    I attached you a excel file with the result i wanted.( ofcause without VBA prgm).
    Sheet 1: "data GR" with 2 tables and values. I'm only intresseted in column F (scrap %)and column H(scrap cost).
    What i want is: one the column F or H are "RED" ( it means values in the col F > col G, or Col H > Col I), so then i want to projet a graph on the Sheet 2 ("Chart GR").
    Important: the chart should only take 4 weeks before from the "red" apprears. and that graph got 2 Yscales (left side:Scrap %; Right side: Scrap cost) and one X scale (with 4 weeks).

    I really don't know where to start it, i need your support please.

    Thank you.
    Attached Files Attached Files

+ 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. [SOLVED] VBA SQL Creat table
    By dugdugdug in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-10-2012, 01:11 PM
  2. Creat Pivot Table with a Macro
    By ranaamir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2008, 04:07 AM
  3. Creating two different charts based on a single pivot table based on condition
    By exlnovice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2008, 06:21 AM
  4. HOW TO CREAT 3 AXIS CHARTS
    By chrisH in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-01-2006, 10:50 PM
  5. [SOLVED] can i creat sub-charts from an existing chart?
    By JKelly in forum Excel General
    Replies: 2
    Last Post: 04-21-2005, 01:06 PM

Tags for this Thread

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