One of the more annoying things about Xcelsius charts is its inability to show data lables. That is to say, you can’t see the values of each data point on a chart without hovering over each point. In this video, I show you how you can leverage one of Excel’s oldest tricks to actually show chart values without hovering. Even cooler than that, I show you that you can do this without adding a data grid, textbox or any other component to the chart visualization. That’s right, show chart values without the aid of any other components. Enjoy!!

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

Have you ever created a Line chart, then decided you needed a Column chart? Making the switch between chart types is easy in Excel, but in Xcelsius there is no way to quickly change chart types. You simply have to start over. That means adding a new chart to your canvas, re-doing all your configurations, an apply the formatting as needed.

Well in this video, I show you how a simple charting best practice and save you tons of time and energy.

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.