Create a Dynamic Pie Chart with Dynamic Legend in Excel which Doesn’t Display Zero Amount Categories, and Adds or Removes Categories & Updates Dynamically with the Entered Data

In the Screenshot above, this Pie Chart will adjust automatically to new values added into the Excel Sheet, adding or removing new categories as values are entered or deleted. I have something like around 80 different Categories, but each day perhaps only 10 or so get used, but they could be any 10 of the … Continue reading Create a Dynamic Pie Chart with Dynamic Legend in Excel which Doesn’t Display Zero Amount Categories, and Adds or Removes Categories & Updates Dynamically with the Entered Data

Advertisements

Rename Text & HTML Files using text from within the Document itself as the New Name

Download Here: Replace Pioneer Instal & Run Tools> Batch Runner "Pick Files" Check the box Set Output File Name Type in ${FIRSTLINE}.txt into the box, or ${FIRSTLINE}{1,9} for only the first 9 characters, or ${FIRSTLINE}{lc}.txt for lowercase, Put a "$" before each class, for example ${FILENAME}${FIRSTLINE}{lc} will add the first line of text to the … Continue reading Rename Text & HTML Files using text from within the Document itself as the New Name

Horizontal to Vertical Data Switch & Ghost Switch in Excel

In the Image above, the Top table is the original horizontal table I created The bottom-right is the table converted to a Vertical table, totally independent of the first table, the first could be deleted in place of this table, if desired. The bottom-left table is a ghost-copy of the first, which changes automatically when … Continue reading Horizontal to Vertical Data Switch & Ghost Switch in Excel