Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Offset?
I want to populate a chart from a drop-down box, and I think I need to use
the OFFSET function somehow, but can't get it to work. I have a list of about 50 products listed in col C with six rows (13 columns) of data starting in column d under each product. If the user selects product #16, I need to determine how to populate the chart source data with that product's information. I've been trying to use OFFSET, but don't know how to tell it use the absolute address of each product for the reference. Week 1 Week 2 Week 3 AccountA 1 Product 1 Fact 1 5659 0 0 Fact 2 0 0 0 Fact 3 5.8846 0 0 Fact 4 5.8846 0 0 Fact 5 1.6923 0 0 Fact 6 1.6923 0 0 2 Product 2 Fact 1 20435 1038 398 Fact 2 2.4054 86.3555 -13.1004 Fact 3 22.7692 26 22 Fact 4 -1.5769 1 -1 Fact 5 9.2692 11 5 Fact 6 0.5769 5 -1 As usual, any help is greatly appreciated. Patrick_KC |
#2
|
|||
|
|||
Patrick,
A formula expression could probably be written to isolate the records for a given product, but it would likely be a bit messy. And geeky. Simple is always better. A better solution in general is to rearrange your table so there is only one record layout -- do away with the header records (product), and have a product column with product in it in each record for the records of that product. Much of Excel's functionality is lost with multiple record types. I was going to make an example, but you've posted in html using a non-proportional font, and Outlook Express won't let me reply in plain text today. Consequently, a table would snake all over the place in the proportional font used here. But I hope you get the idea. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Patrick_KC" wrote in message ... I want to populate a chart from a drop-down box, and I think I need to use the OFFSET function somehow, but can't get it to work. I have a list of about 50 products listed in col C with six rows (13 columns) of data starting in column d under each product. If the user selects product #16, I need to determine how to populate the chart source data with that product's information. I've been trying to use OFFSET, but don't know how to tell it use the absolute address of each product for the reference. Week 1 Week 2 Week 3 AccountA 1 Product 1 Fact 1 5659 0 0 Fact 2 0 0 0 Fact 3 5.8846 0 0 Fact 4 5.8846 0 0 Fact 5 1.6923 0 0 Fact 6 1.6923 0 0 2 Product 2 Fact 1 20435 1038 398 Fact 2 2.4054 86.3555 -13.1004 Fact 3 22.7692 26 22 Fact 4 -1.5769 1 -1 Fact 5 9.2692 11 5 Fact 6 0.5769 5 -1 As usual, any help is greatly appreciated. Patrick_KC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to offset the y-axis of a chart without having the. | Charts and Charting in Excel |