Sand | search
Click here to view Sand news from 60+ newspapers.
Bookmark or Share- Create a Map chart in Excel - Microsoft SupportCreate a Map chart in Excel. Applies To. You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.
- Create a chart from start to finish - Microsoft SupportLearn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
- Create a waterfall chart - Microsoft SupportCreate a sunburst chart in Office. Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
- Change the plotting order of categories, values, or data seriesReverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
More
