Forum Discussion
Need help in creating line charts from a data set
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
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