+ Reply to Thread
Results 1 to 11 of 11

Extend chart so can see curve better

  1. #1
    Registered User
    Join Date
    04-26-2023
    Location
    United Kingdom
    MS-Off Ver
    MS365 V. 2303
    Posts
    5

    Extend chart so can see curve better

    Hi,
    I wish to view the data (x vs y) in a very very long chart...so the curve lines are not so "overlapping".
    Do you know how i can do this?

  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
    80,933

    Re: Extend chart so can see curve better

    Did you try dragging to make the chart bigger?

    Please uspdate your profile to say "MS365 v. 2303". Thanks.
    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.

  3. #3
    Registered User
    Join Date
    04-26-2023
    Location
    United Kingdom
    MS-Off Ver
    MS365 V. 2303
    Posts
    5

    Re: Extend chart so can see curve better

    Thanks, yes i tried that, but i have loads of data points, and i spent 10 mins extending it, but still not enough yet.

  4. #4
    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
    80,933

    Re: Extend chart so can see curve better

    OK - sorry, then, but I can't help. Someone else will know how.

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Extend chart so can see curve better

    There is probably too much data there. Use PivotTable to group the x values by say 100, then summarize y values by Average. Plot the chart.

  6. #6
    Registered User
    Join Date
    04-26-2023
    Location
    United Kingdom
    MS-Off Ver
    MS365 V. 2303
    Posts
    5

    Re: Extend chart so can see curve better

    Thanks, though i would like to have loads of little graphs which can be scrolled through.....i have done 14 of these so far.....
    but still loads to go.....any quick way of doing this...i dont want to average...i want people
    to be able to peruse all the data.

  7. #7
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Extend chart so can see curve better

    Please attach a sample workbook.

  8. #8
    Registered User
    Join Date
    04-26-2023
    Location
    United Kingdom
    MS-Off Ver
    MS365 V. 2303
    Posts
    5

    Re: Extend chart so can see curve better

    Thanks, please find attached..the graphs so far.
    Aaaah, i dont seem to be able to attach anything?

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Extend chart so can see curve better

    Please refer to the yellow banner at the top.

  10. #10
    Registered User
    Join Date
    04-26-2023
    Location
    United Kingdom
    MS-Off Ver
    MS365 V. 2303
    Posts
    5

    Re: Extend chart so can see curve better

    Thanks, please find attached...sorry again...its 2MB and too big to attach.
    Please find jpeg which hows whats going on....i am havign to do loads of little charts...and its taking ages.
    I need the little charts otherwise the points are kind of overlapping.
    How can i do loads of little charts quickly?
    Attached Images Attached Images
    Last edited by eem2am; 04-26-2023 at 01:20 PM.

  11. #11
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Extend chart so can see curve better

    Picture is of no use. Try to compress the file or alternatively delete some rows/columns.

+ 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. [SOLVED] Extend line chart in a combo chart
    By lynnsong986 in forum Excel General
    Replies: 1
    Last Post: 02-24-2023, 10:11 AM
  2. [SOLVED] VBA code to extend a Chart
    By RobinClay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2020, 06:42 AM
  3. Extend colour in chart
    By alee001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2019, 01:29 AM
  4. Chart series don't extend
    By JayeshG in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-03-2019, 03:35 PM
  5. Extend chart range
    By charm1 in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 08-11-2017, 04:56 PM
  6. Extend chart title
    By SoftwareTester in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2009, 05:12 AM
  7. Extend the last bar in a bar chart
    By computeruser08 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-03-2008, 11:18 PM

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