As we’ve seen in the past, XL3Link is a flexible formula that is really worth knowing about to help easily build interlinked reports. To some extent it’s like a Swiss army knife – multi-purpose! From highlighting a series on a chart to hosting a tooltip, XL3Link is a flexible formula that can help make your reporting more interactive at multiple levels.
In this post we’ll be discussing a few more novel ways to use XL3Link.
Continue reading “Linking it all together”
XLCubed is a great tool when it comes to member searching: it allows you to quickly and easily find members as well as dynamically update a report based on search parameters. Take a read of our last post to get started with this functionality.
The example in this post uses these searching methods to create a product search page. The left side provides search functionality for all the products contained in the cube, with a link to select the product which displays the full details on the right side.
Continue reading “Member Searching To Create A Product Details Page”
Many would believe that Excel is a static environment and not suited for making responsive mobile reports. XLCubed users know better. With XLCubed’s Dashboard Designer, it is possible to create dashboards that are not only interactive and data-connected, but also responsive to fit any device.
Continue reading “Dashboard Designs: Responsive Navigation Bars”
There has been a lot of criticism regarding Excel 2007, particularly about the new chart engine, the UI inconsistencies and the Ribbon. Jorge yesterday concluded that Excel 2007 is Useless and Jon wrote a comprehensive analysis about Changes to Charting in Excel 2007 where he expressed his concerns regarding the new Charting. In 2006 Stephen Few reviewed Excel 2007 charting and concluded Excel 2007 charting Preview of an Opportunity Missed. Charley Kyd did a survey about How Do Business Users Like the Ribbon and came back with the result that about 56% of all respondents had a negative opinion about the Ribbon
Continue reading “Microsoft, Pimp Down My Ribbon”