+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 charts

  1. #1
    Registered User
    Join Date
    08-03-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel 2013 charts

    I am using excel charts to plot price v/s historical volatility

    My one question is that excel formats the charts from 0 to the highest number on the dataset.

    How can I automatically scale the chart to get that range only..... or do I have to resort to manually doing it for all?

    Any ideas???

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Excel 2013 charts

    Welcome to the forum.

    Are you still using Excel 2007 or have you upgraded? You should be able to set up one chart and save it as a template, then use that template for your other charts.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Additional charts/visuals for excel 2013
    By michal_j in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2018, 09:04 AM
  2. Tree Map charts in Excel 2013?
    By michellepace in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2015, 08:10 AM
  3. [SOLVED] Excel 2013 2D/3D Surface charts-editing band size?
    By I-Like-Excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-24-2015, 07:48 AM
  4. Formatting Charts on a protected sheet - Excel 2013
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2014, 12:39 AM
  5. [SOLVED] Renaming Charts in Excel 2013
    By misterk in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-02-2014, 06:08 AM
  6. VBA charts work fine in excel 2013 but not in excel 2010
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2014, 08:05 AM
  7. XY Scatter Pivot Charts in Excel 2013?
    By emesgee in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 12:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1