Results 1 to 2 of 2
Thread: Graphical what if's? (Excell 97)
2003-04-10, 22:23 #1
- Join Date
- Apr 2002
- Libby, Montana, USA
- Thanked 0 Times in 0 Posts
Graphical what if's? (Excell 97)
Here is the problem, I would like to ba able to create a graphical view of two related fields of "name" and "BidAmount" and be able to connect them to two other related fields of "product" and "productcost". I would like to show the percentage value of "BidAmount" to "productcost". I would like to be able to move and connect "name and Bid Amount" fields to other "product and productcost" fields then have the new percentage values update without having to recreate the formula. Am trying to use colored fill in the fields and seems to be graphically sufficient. I have 200 sets of "name and BidAmount " and 200+ sets of ""product and productcost" values and woul like to be able to edit "BidAmount" and "productcost" fields as well as add new sets of each.
2003-04-10, 23:18 #2
- Join Date
- Dec 2000
- Salt Lake City, Utah, USA
- Thanked 6 Times in 6 Posts
Re: Graphical what if's? (Excell 97)
You are asking a complete cradle-to-grave question, beyond the general scope of Lounge assistance. Since you posted in both Access and Excel, here's some things ot consider:
Do you already have this data in some form of data base?
Does or will this data build up over time longitudinally?
Do or will you want to take a series of periodic snapshots from longitudinal data?
Does or will this data need to contain master or key fields, such as customers who make series of purchases, and prducts which any customer can purchase?
If the answer to these leans towards yes, you need to use or create a relational database such as Access. If the database already exists, and you want to query it and analyse the "snapshot" results, then you need to determine what fields are to be queried and determine if the data is best analysed in Access or Excel.
Then you need to determine what kind of analysis you want, such as do you want percentage of sales volume per customer, percentage of revenue per customer, percentage of sales volume per product, percentage of revenue per product, corresponding averages, etc.
After you get that far, you need to provide more detail on what kind of graphical presentation you have in mind. A small sample of data would be helpful.-John ... I float in liquid gardens