slices

  1. C

    Value error on simple formula

    HI. I'm using Excel 2013 where the file type is .xlsx using this ='tab name'!E30 returns the (correct)value 50 However if I use this ='tab name'!e30&" Slices" I get a value error where I am expecting "50 Slices". If I use the formula evaluating tool it resolves to "50 slices" but the next...
  2. Y

    Limit display data on dashboard - large report

    Hi All, I have a large report that I am building a dashboard for with slices, it looks great and manageable when I filter the pivot tables to show the top 20 rows but when I use the slices on the dashboard the charts show all the data and it is impossible to visualize properly. Does anyone...
  3. N

    Power Pivot to Dashboard problem

    At the moment I am having a huge problem trying to figure something out and I feel it is going to be either a PowerPivot and slice job but can’t figure out how to get the chart to show on the results in the dashboard. I have a load of data that has come from different cities and venues in...
  4. D

    Slices

    Is it possible to anchor or fix slices in Excel 2010. I would like to keep the menus fixed to top of the page or a partciular cell if possible...all help appreciated.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top