hide data in pivot table/diagram?

[Jorgensen]

hi

i guess it's quite simple but....is it possible to hide some data in a pivot table /diagram, but still sort by the data?

if i have two coloums name and hours
a 10
b 20
c 30
d 40
e 50
f 60
g 70

is it then possible to sort names after amout of hours - and to hide the hours?

thanks
jorgensen

 

[Jorgensen]

Anyone?

 

[flyonthewall]

Yeah --- I mean, you should be able to set up the sort and then just hide the column? Just because something is hidden doesn't mean it can't be used in a calculation or referenced.

 

[Jorgensen]

hi

i guess it's simple, but i simply can't figure out how to hide a column - can you guide me?
or - i sould be more exact - i would like to sort by value, but hide the value in the chart.

i have figured out how to hide the column, but not in the chart :-/

screenshot
https://www.dropbox.com/s/vysu7bzbmxv15xz/2.PNG?dl=0

excel
https://www.dropbox.com/s/rj0gzvip33l1eq0/1.PNG?dl=0

 

[Jorgensen]

doh - i can just select and delete the bars

 

[Jorgensen]

but - it's not possible to delete the bars every time - and they come again if the chart data is modified

and if the 'value' is a very small number, and factor i a very high number - it's impossible to select the 'value' bars

there must be a smarter way to hide some data?

thanks
Jorgensen

 

[Jorgensen]

i really can't figure out how to solve this - is it really not possible to sort an pivot table with a hidden colomn?

can it be done by using VBA?

i have added a screenshot and a table that shows what i'm trying to achive.

Jorgensen

screenshot
https://www.dropbox.com/s/60xa44gm7ba9328/10.PNG?dl=0

excel
https://www.dropbox.com/s/440xeo11xa7ohhf/10.xlsx?dl=0