Pie Charts in Web Edition

Chart in Excel before publishing:

FAQ2.png

After publishing to web:

FAQ3.png


To resolve this you need to:

  • Click on the pie chart in Excel and choose Format data series
FAQ4.png
  • choose solid fill rather than automatic and choose a fill colour - this will set everything to one colour
  • then right-click to select each data series individually and choose Format Data Point and set to the appropriate colour for each one

Having done that it will publish as you see it in Excel.


FAQ5.png