hi
new to excel and new to this forum :-)
i have just started using excel with the goal to visualize some of our firm-data.
i have therefore read a bit about pivot tables, and have been experimenting a bit.
WHAT I TRY TO DO
i try to compare subjects factors to hours used, but setting up two charts.
PROBLEM
but i have got a problem (i guess it's quite simple) that i can't solve.
i have a table that contains
- subject
- hours
- factor
those data i would like to precent in to charts
CHART ONE - FACTOR
- shows the subject
- sorted by factor
- shows the factor
CHART TWO - HOURS
- shows the subject
- sorted by factor
- shows the hours
i can set up the charts, and sort them as needed - but i can't figure out how to hide the factor-bars in the HOURS table?
does anyone know how to do that?
A SECOND PROBLEM
if there are a lot of subjects, and some of them has a factor of '0', then the subjects are not alway sorted the same way in the two charts.
to solve this i guess i need to "sort by FACTOR, then by SUBJECT" but is that possible?
thanks
jorgensen
Bookmarks