by Nate Moore | Jan 12, 2015 | Charts
Excel Video 442 shows you how to control the horizontal and vertical axes for your charts. Notice the new Chart Elements menu (the plus sign) and different ways to select the area on the chart you want to edit. Most of the options for controlling axes are fairly...
by Nate Moore | Jan 5, 2015 | Charts, Excel 2013
Happy 2015 everybody! We’re kicking off the new year with a new series about Excel 2013 Charts. We’ll start with a new feature in Excel 2013, Recommended Charts. Watch how Excel reviews our data and provides recommendations for how to chart the data. It’s easy to see...
by Nate Moore | Mar 9, 2011 | Charts
Excel Video 138 adds the finishing touches to our scrolling chart. Today we’ll add the scroll bar. To add the scroll bar and other programmable items to your spreadsheet you need to have the Developer tab displayed. If you’re in Excel 2010, I’ll show you the box to...
by Nate Moore | Mar 7, 2011 | Charts
Excel Video 137 uses the named ranges we created in the last Excel Video to update our charts’ data sources. We’ll start with the top chart. We need to change the data we’re plotting to be the named range Collect2 and the horizontal axis to look at the named range...
by Nate Moore | Mar 2, 2011 | Charts
Excel Video 136 takes advantage of the OFFSET tricks I discussed starting with Excel Video 85. If you missed those videos or it’s been a while since you’ve used OFFSET, spend a few minutes watching the videos starting with Excel Video 85. The beauty of OFFSET is that...
by Nate Moore | Feb 28, 2011 | Charts
Excel Video 135 is an easier video than Excel Video 134. Today we’re simply going to set up the charts we need for the scrolling data. Since I want the charts to have similar formatting, I set up the bottom chart first and get it close to what I want. Once I’m most of...
