Hi All,
I have a data set (see attached example sheet). How can I create a pivot chart to display a specific parameter with a specific sample ID over time. for example I would like to display ammonium RAW_WATER and ammonium OUTFLOW over time.
Thanks,
I have created the pivot chart. I just want to change the chart type to markers instead of line or bar which does not allow me. any idea how I can do that or that is not a feature allow me to do? if not, any alternative way instead of pivot chart to do it?
You should be able to right click the chart and pick Change chart type.
I can only pick pie, bars, line but not scatter.
Pivot charts do not support any of the xy-scatter or bubble chart types.
If you want those you will have to use a normal chart based on range occupied by pivot table. Take care when selecting data otherwise excel will turn chart into pivot chart
can I create a normal chart with drop down list to display specific parameter with specific sample ID over time?
Not built in to the chart, cause that would be a pivot chart.
You could add slicers to control the pivot table content. Then with vba code update the chart to use the correct data.
The attached contains a chart as per your original description, just is case you don't need a scatter.
Thanks Andy, I have got this far but when I have more data it will categorise the dates which annoys me and I need to have them in days
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks