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?
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?
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.
Thanks, yes i tried that, but i have loads of data points, and i spent 10 mins extending it, but still not enough yet.
OK - sorry, then, but I can't help. Someone else will know how.
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.
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.
Please attach a sample workbook.
Thanks, please find attached..the graphs so far.
Aaaah, i dont seem to be able to attach anything?
Please refer to the yellow banner at the top.
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?
Last edited by eem2am; 04-26-2023 at 01:20 PM.
Picture is of no use. Try to compress the file or alternatively delete some rows/columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks