Forum Discussion
Need help in creating line charts from a data set
Hello,
Need assistance in creating line charts from a huge data set using some tool or formula. New to excel and don't know much about the details in excel where i can create the same for a huge data set.
The data contains 3 columns and 100k rows from which i need to plot a line chart for every 12 rows, so can anyone suggest me how do i do it using some formula or any different method as i have no clue how to do it.
Currently using office 365.
Awaiting some response.
Regards,
Aditya
12 Replies
Not 100% sure about what you need, but maybe this helps a little...
Best, Oliver
Dear Oliver,
Thank you so much it helped me a lot but i need the Water level and temp plot in the same graph to compare. Both on the separate axis would have helped me a lot. i.e if the water levels are on the primary axis then the temp goes on secondary axis, thats what i wanted so if you can help me in that matter please suggest me how do i do that.
Regards,
Aditya
okay. :)
let me know if you need something else...
Best, Oliver
