Mgiyuk

Pivot Chart/Pivot Table blank/missing data to hide on table I hope everybody is well! Quick question I have concerning Pivot Tables and Pivot Charts. I have quite a quantity of data that I am trying to put into a Pivot Chart, however it also creates space for data that is blank and therefore make the pivot chart very small and hard to read. I've been trying to find a solution for my problem for quite some time and wasn't able to find anything. enter image description here What I would like to achieve not to have the data that is blank showing in the pivot chart. Thank you ! How about uploading a higher resolution picture. I can't see what's going on in that one. – jeffreyweir Jun 28 at 21:50 Thanks for the reply. I've updated the picture with a better resolution. Due to the huge amount of data...

How to have piechart over a geomap in google charts? I would like to achieve a similar result as presented in the picture below using google charts: By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

phpspreadsheet - lines without markers in chart I am using phpspreadsheet to generate line charts. Almost everything is fine, but I don't get how to change plot style. Here is what I have: function createChart($sheet, $sheetname, $data) { $count = $data["custom"]["count"]; $sheet->getColumnDimensionByColumn(1)->setAutoSize(true); $sheet->setCellValueByColumnAndRow(1, 1, $data["custom"]["type"]); for($j=0; $j < $count; $j++) $sheet->setCellValueByColumnAndRow(1, $j + 2, $data["custom"]["dates"][$j]); for($i=0; $i< count($data["series"]); $i++) { $sheet->setCellValueByColumnAndRow($i+2, 1, $data["series"][$i]["name"]); $sheet->getColumnDimensionByColumn($i+2)->setAutoSize(true); for($j=0; $j < $count; $j++) { $value = $data["series"][$i]["data"][$j] ? $data["series"...