The first step is to create your statistical data in its simplest form. If you're starting with a blank worksheet, type your column and row parameters, and insert your data. If you wish, you canformat your Excel tableso that it's easier to add more data later on. If you already have...
map looks chalky. If I leave certain lines off and restrict extra data (all those state names you forgot) then it looks like some child (okay, maybe this child) doodled a map on the wall. As usual, the trick isgetting rid of the base and clearing the worksheet color. You’re ...
withtheoldestatthebottomandyoungestatthe top.Theyalsoshowtheirthicknessesandare usuallydrawntoscale.Thecrosssectionsshow thesub-surface(andoftentheabove-surface) geology,aspredictedfromthefeaturesmapped atthesurface Mapscomeinavarietyofscalesdepending ontheamountofdetailneededfordifferent purposes.Inallcases,they...
Copy Tushar’s code to your workbook and adopt it according to the cell ranges of the mapping table and the color range table in your workbook. With every worksheet_calculate (or any event you may choose), the VBA code loops through the mapping table and assigns the fill color to every ...