How to display days proportional to data collected

[SimonK]

Hello Everyone, Please see the attached image. I'm having trouble with a pivot generated graph to show dates on the 'X' axis to show the scale proportionally to when the data was collected. I've aimed to collect data every second or third day but sometimes there were 5 days between readings and the time difference is not shown in the scale on the x axis. There is no proportional recognition on the x axis it seems. Please let me know what I need to do to fix this as I've tried all I can see to fix and nothing has worked. Thanks for reading. Cheers!

 

[Hui]

Try changing the chart type to an XY Scatter chart type

 

[SimonK]

Try changing the chart type to an XY Scatter chart type

Thanks Hui! I tried this now and was told that I can't create this type of chart inside a Pivot Table. I've now copied the data outside of the pivot and used it to create an XY scatter and the data now plots with proportions between dates shown correctly. It would be save a lot of extra work if this could be done directly from a pivot but I guess the flexibility of Excel Pivots has some limitations. Cheers, Simon

 

[NARAYANK991]

Hi Simon ,

Have you followed the technique outlined in the link given by Jon Peltier here ?

https://answers.microsoft.com/en-us...ble-when/cfea2d13-35e1-42c1-9341-a3a30ae48805

Narayan

 

[SimonK]

Thank you Narayan! The link you provided is completes what I needed to know on this issue for now.