#1
|
|||
|
|||
Dynamic Chart with Non Continuous data
Hi all.. this is my first time here so apologies for any formatting issues.. i have attached the relevant file with my data..i have input all the purchases as positive numbers and the sales that i make as negative numbers.. I am trying to create dynamic charts for the different products that i sell..also i would need dynamic charts for the products sold by a specific DSR..i know i would have to use OFFSET with COUNTIF but i am unable to get around the correct formula..also i am not sure how to convert the negative sales numbers to positive for charting purposes.. Can someone please help me..i have spend numerous hours trying to work it around but i am unable to find a solution |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert a picture into word using DDE (Dynamic Data Exchange) | sasdde | Word VBA | 5 | 06-21-2013 01:21 AM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data | ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
Chart Over 7,000 Data Points | Karen615 | Excel | 4 | 06-28-2011 10:08 AM |
chart from large data set | mcfie | Excel | 1 | 09-19-2010 03:11 AM |
One bar chart for 3 sets of data | rclloyd | Excel | 1 | 02-03-2006 09:51 AM |