by Nate Moore | Aug 23, 2010 | Charts
Excel Video 86 walks you through two of the three steps to use OFFSET to automatically update charts as we discussed in Excel Video 85. You’ll remember Excel Video 85 explained the need to use OFFSET, define a name, and use that name as the chart’s data source for a...
by Nate Moore | Aug 18, 2010 | Charts
Excel Video 85 starts our discussion of OFFSET, a powerful Excel function you can use to update your charts automatically. If you’ve missed some of the basics of charting videos because you’re familiar with charts in Excel, it’s time to start watching again. We’re...
by Nate Moore | Aug 16, 2010 | Charts
Excel Video 84 shows you two ways to add noncontiguous data to a chart. Noncontiguous data is data that isn’t stored next to your existing chart data. You can easily add that data to your chart by copying the data (including appropriate headings), selecting the chart,...
by Nate Moore | Aug 11, 2010 | Charts
Excel Video 83 demonstrates two methods to add contiguous data to a chart. Contiguous simply means that the data you want to add to a chart is right next to the existing chart data. There are several ways to add data to a chart. I’ll demonstrate two in Excel Video 83....
by Nate Moore | Aug 9, 2010 | Charts
Excel Video 82 is a cool way to add some color to your chart. The area of the chart where the data is actually plotted is called the Plot Area. You can change the background of the Plot Area from the default white to a solid color, a gradient fill, a texture, or any...
by Nate Moore | Aug 4, 2010 | Charts
Excel Video 81 is a quick look at Gridlines in charts. I’ll demonstrate the difference between major and minor gridlines for both the horizontal and vertical axis. This is pretty straightforward and there aren’t many formatting options, either. The ability to tweak...
