by Nate Moore | Aug 2, 2010 | Charts
Excel Video 80 focuses on how to change and format the Vertical Axis. It’s easy to change the units (thousands, millions, etc.), which side of the chart the Axis is on, and to reverse the axis so the lower values are on the top of the chart. The heart of Excel Video...
by Nate Moore | Jul 28, 2010 | Charts
Excel Video 79 reviews some of the options for formatting the Horizontal Axis on charts. It’s easy to reverse the order of categories on the axis (from Dr. D to Dr. A and vice versa) and to hide the horizontal axis if you need to. Many of the Axis Options for the...
by Nate Moore | Jul 26, 2010 | Charts, VLOOKUP
Excel Video 78 explains Data Tables. Data Tables are an easy way to show the data you’re charting as part of the chart. The more features you add to a chart, less room there is for the actual chart. Watch Excel Video 78 to see how to include the Chart Legend as part...
by Nate Moore | Jul 21, 2010 | Charts
Excel Video 77 covers Data Labels, a way to label your chart data with the numbers behind the graph. Sometimes you’ll find it helpful to not just chart the data, but to show the detail of the data on the chart. Some doctors may benefit from the graphical or visual...
by Nate Moore | Jul 19, 2010 | Charts
Excel Video 76 offers a variety of different ways to customize a Chart Legend, a key on the chart that shows which colors represent which data. You can easily move a Chart Legend to a variety of places on a chart, or you can drag the legend wherever you need it. You...
by Nate Moore | Jul 14, 2010 | Charts
Excel Video 75 introduces Axis Titles, a way to add a description to the horizontal and/or the vertical axis. Many well-designed charts don’t need an additional description for either axis. In the collections example, by titling the chart, “Collections,” including...
