Forum Discussion
Need help in creating line charts from a data set
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
Dear Oliver,
Thank you so much for the solution its the exact thing which i wanted and it has made my work very very easy now. But there is just one problem when i copy and paste the chart in another sheet it changes as soon as i click on the second data sheet in the pivot. What do i need to do so then i can get the charts out in an presentation or any other place.
Regards,
Aditya
Hi Aditya,
what I did is I created a Pivot Chart. If you copy this, it is always connected to source and their used filters (TimeFrame). There are ways to disconnect them, but I wouldn't suggest to go this direction. What I would suggest is to copy the chart and past it as a picture.
1. copy the chart
2. rightclick on any cell
3. click the below shown little icon :)
Additional i added a small overview in a new sheet.
Have fun!
Best, Oliver
Hi Oliver,
Thanks for the option and really appericiate the help and it was very useful you have saved my lot of time and thanks again for the help.
Regards,
Aditya