XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Pie Charts in Web Edition"

(Created page with "Chart in Excel before publishing: 350px|centre After publishing to web: 350px|centre To resolve this you need to: * Click on the pie ch...")
 
 
(3 intermediate revisions by 2 users not shown)
Line 9: Line 9:
  
 
To resolve this you need to:
 
To resolve this you need to:
* Click on the pie chart in Excel and choose ‘Format data series’
+
* Click on the pie chart in Excel and choose ''Format data series''
  
 
[[Image:FAQ4.png|350px|centre]]
 
[[Image:FAQ4.png|350px|centre]]
  
* choose ‘solid fill’ rather than automatic and choose a fill colour - this will set everything to one colour
+
* 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
+
* 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.
 
Having done that it will publish as you see it in Excel.
Line 20: Line 20:
  
 
[[Image:FAQ5.png|350px|centre]]
 
[[Image:FAQ5.png|350px|centre]]
 +
 +
[[Category:Web Edition]]
 +
[[Category:Troubleshooting]]

Latest revision as of 15:18, 23 August 2012

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