Posted by Jozef Marak on February 27, 2001 4:09 AM
I have the problem with the Excel data evaluation. Why? I would like to describe my problem in the example. I created Excel file containing my data arranged in the following way:
1. I have several worksheets (12, one for each month) in my file;
2. each worksheet contains 3D data arranged like this
Item Paid Tax
car 85 12
food 41 8
beverages 15 2
My problem is that I would like to see my data from this point of view
"How much did I pay for the food through the whole year?"
It means it is necessary to pick let say only one value (cell crossing "food" and "Paid") from each sheet (month) and to create the graph. I was not able to do this with Excel.
Is there any solution of the problem like this? I don't want to rearrange the table because the number of items is hundreds.
Any advice is very appreciated.