Microsoft Office Tutorials and References
In Depth Information
Figure 5-37. Excel sparklines and conditional formatting
Choose a specific design format for the sparklines from ➤ Design. Select high point, low
point, First point, and last point (Figure 5-37 ). add a header title for the column, such as
FY2006 ~ FY2009.
let’s add a trend to this sheet; we’ll add a rather simple one. let’s get trends on the difference in Sales amount
from FY 2004 and FY 2002. Note that if you’re using the adventureWorks DW database, you’ll have data for
FY2006 through FY2009.
place the difference formula between D3 and B3, and choose column h to display the results.
repeat the step for the range D4:D7 and B4:B7.
Select all the calculated columns (h3:h7). From the Styles section on the home tab, click on
Conditional Formatting and then on Data Bars. Select the green data bar and then Gradient Fill.
■ there are many other conditional formats, designs, and layouts you can use. We recommend you try other
options for styling the sparklines and charts.
after you add sparklines and conditional formatting to the sheet, it should look similar to what’s shown in Figure 5-38 .
Figure 5-38. Sparklines, conditional formatting, and graphs in Excel
What would be more interesting is if you could add an intuitive mechanism to the sheet for analyzing data. and
you can add the Slicer in excel that you can use to filter data, and slice and dice it.
Search JabSto ::