If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a graph from a vlookup?
Hey there, newbie here. Having a data sheet named 'Wines' using a vlookup
table for the sales, I have sales sheets for each day (1st, 2nd..) that work with dropdown combination boxes when something is claimed. It's a simple setup. Is it possible to create a graph from all the products sold that month (from each day sheet) by product selection? Is it a pivot table I need? How to? Really need help on this one. Example: From August, day 1-31, 20 products named Redwine Classic, 31 Redwine Risling etc were sold and were selected from the sales sheet using vlkup from the datasheet tally up sales that day in value. But I would like to graph these 51 sales that MONTH in another sheet and be able to choose what products I want to graph. I need Redwine Classic to be graphed only or grpah all products sold that month. How in the earth do you do this??? Be very helpful on how to do. Regards Sean |
#2
|
|||
|
|||
Create a graph from a vlookup?
A pivot table would let you filter by date, group dates into months or
quarters, or filter by product name. It might be worth spending a half hour with pivot tables, to learn how powerful they can be. I have a simple intro to pivot tables on my site (written mostly by Debra Dalgleish) which also includes links to other PT resources: http://peltiertech.com/Excel/Pivots/pivotstart.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sean" wrote in message ... Hey there, newbie here. Having a data sheet named 'Wines' using a vlookup table for the sales, I have sales sheets for each day (1st, 2nd..) that work with dropdown combination boxes when something is claimed. It's a simple setup. Is it possible to create a graph from all the products sold that month (from each day sheet) by product selection? Is it a pivot table I need? How to? Really need help on this one. Example: From August, day 1-31, 20 products named Redwine Classic, 31 Redwine Risling etc were sold and were selected from the sales sheet using vlkup from the datasheet tally up sales that day in value. But I would like to graph these 51 sales that MONTH in another sheet and be able to choose what products I want to graph. I need Redwine Classic to be graphed only or grpah all products sold that month. How in the earth do you do this??? Be very helpful on how to do. Regards Sean |
Thread Tools | |
Display Modes | |
|
|