How To Index

Listed below are all my "how to" articles explaining how to perform an action, how to use specific functions, how to create complicated formulas to perform a specific task, and how to create VBA macros to automate repetitive processes. See 76 of my best Excel Tips in my ebook, available in Kindle and PDF formats.

Actions: How To



Functions: How To



Formulas: How To


 

VBA Macros: How To


Video Tutorials: How To

Misc. How To


Last updated: 3/22/22

1 comment:

  1. I have a clustered column chart built from a pivot table. The legend coloring is as follows:
    Blocked - blue
    Fail - red
    In Progress - gray
    Not Executed Orange
    Pass - Green

    I inserted a slicer for different departments (i.e. marketing, development, accounting). When I select a "slice", my legend colors are not the same.

    How can I make the slicer take on the color properties of the legend in the chart?

    ReplyDelete

I'd love to hear from you!
-Nick