Wednesday, October 23, 2019
City Streets
The direction of streets in cities can tell you a lot about its geography and history: Urban Street Network Orientation is a nice data viz of that.
MS Excel and Google Sheets on Steroids!
I admit: I use MS Excel a lot and I'm still amazed how much more there is 'under the hood' in terms of functions, analysis options, and charting tricks - here are a few good ones I came across recently:
- An Empty Bar (Ann K. Emery)
- Removing the Double Y Axis (Ann K. Emery)
- VLookup (Ann K. Emery)
- From Data to Charts in 5 minutes (Ann K. Emery)
- Excel Elbow Grease (great tricks by Ann K. Emery)
- Muted Grid Lines and Area Charts (Ann K. Emery)
- Number Formatting / Conditional Formatting (Ann K. Emery)
- Formatting Months, Days, and Years in Excel (Ann K. Emery)
- Label Axis and/or Data? (Ann K. Emery)
- Formatting Names (Ann K. Emery)
- Sorting and Filtering your Spreadsheets (Ann K. Emery)
- Place Labels Directly On Line Graph (Ann K. Emery)
- Custom Color Codes in Excel (Anne K. Emery)
- Categorize values with =IF() and =VLOOKUP() (Ann K. Emery)
- How to Use Vlookup in MS Excel (Anne K. Emery)
- How to match data with VLOOKUP in Excel & Google Sheets (Lisa Charlotte Muth)
- Sparklines and Data Bars (Ann K. Emery)
- Add Dotted Lines to Line Graphs (Ann K. Emery)
- Direct Labeling in Excel (Stephanie Evergreen)
- Make a Pictogram in Excel (Stephanie Evergreen)
- Fast Small Multiple Graphs (Stephanie Evergreen)
- Easy Dot Plots in MS Excel (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel I (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel II (Stephanie Evergreen)
- Dumbbell Dot Plots Way Easier (Stephanie Evergreen)
- Make a Slopegraph in Excel (Stephanie Evergreen)
- How to make a scatter plot in Excel (Storytelling with Data)
- Adding a Benchmark Line (Stephanie Evergreen)
- Customizing Colors (Stephanie Evergreen)
- Showing Standard Deviation (Stephanie Evergreen)
- Confidence Intervals to Dot Plots (Stephanie Evergreen)
- Margin of Error in Excel with “Slider Plots” (Andrew Forsman)
- Directly Labeling Excel Charts (Jonathan Schwabish)
- Edit a ledgend in Excel (Storytelling with Data)
- Swimmer Plots (Jon Peltier)
- Pivot Tables (Jon Peltier)
- Interactive data dashboards (Ben Collins)
- Supercategory axis labels (Cole Nussbaumer Knaflic)
- Plotting value within range (Cole Nussbaumer Knaflic)
- Embedding a vertical reference line in Excel (Elizabeth Ricks)
- How to do it in Excel: a shaded range (Elizabeth Ricks)
- How to do it in Excel: adding data labels (Elizabeth Ricks)
- Data prep for MS Excel / Google Sheets (Chartable)
- Extract Text from Data Columns (Chartable)
- Create a dot plot (Storytelling with Data)
- Save As Template (Stephanie Evergreen)
Tuesday, October 22, 2019
Mer de Glace: 1919 to 2019
More details here: Misusing the Georeference Tool for Historic Image Alignment
 |
| https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/misusing-the-georeference-tool-for-historic-image-alignment/ |
Subscribe to:
Posts (Atom)