Custom Charts in Excel with MarketXLS

Discussion in 'Charting' started by marketxls, Apr 11, 2017.

Custom Charts in Excel with MarketXLS

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10


    MarketXLS charts are super easy to use and optimized for plotting stock market information. In another article we learnt about Quick Charts in Excel with MarketXLS. 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 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 x axis. So, these charts are optimized for time series plotting. Also, the charts have crosshairs and they can be zoomed in an out by using mouse scroll.

    The good thing is that you do not need to select any table like 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 “Control” button. So, lets say for example you have data table like below…

    1.png

    Use your mouse scroll button with SHIFT to scroll in or out of the charts.

    2.png

    Click on Shift and drag the mouse pointer to Zoom in or out of any chart

    3.png
     
    #1 marketxls, Apr 11, 2017
    Last edited: Sep 24, 2017

Share This Page