Does anyone know why i can't change the date format on a pivotchart? Have 2
pivot charts running from the same source data - when i created them one
automatically used data format for x axis of d-mm-yy and the other
automatically used d/mm/yyyy. As they are both part of the same presentation
this will look inconsistent, i have tried everyway i know to fix but nothing
works. When you created a normal chart in excel (not pivot) the 'format
axis' option has a 'numbers' tab, but in pivotcharts this option is not
available. Be grateful for any feedback.