Custom Charts in Excel with MarketXLS
MarketXLS charts are super easy to use and optimized for plotting stock market information. Apart from quick charts, you can also create custom charts in excel using any data set.
Simply click on any data series and click on the chart buttons on the menu. Unlike normal Excel charts, MarketXLS charts try to figure out what your data table has and then plot each series as it goes along columns from left to right. If there is a date column it will automatically plot the date and time series on the x-axis. So, these charts are optimized for time series plotting. Also, the charts have crosshairs and they can be zoomed in and out by using mouse scroll.
The good thing is that you do not need to select any table like the conventional way, all you do is select any data cells in your data table and click on Chart. The selections do not have to be contagious, you can simply select any cells by using the “Control” button. So, let's say for example you have a data table like below…
Use your mouse scroll button with SHIFT to scroll in or out of the charts.
Click on Shift and drag the mouse pointer to Zoom in or out of any chart.