If I want to create a chart of the data, but do not want to live with the limitations of pivot charts, then I will simply create a mirror view of the same data then create the chart from that data so I can create a "chart," not a pivot chart. I have done this for one of two different reasons:
Yes - the issue shows up when referencing cells within a pivot table from outside the table. I am not sure if this is still an issue for Karthik or others, but this is the work around I intend to use. One caveat with this: I have not yet confirmed it works on the Mac without any adjustment, although will be shortly. If I knew for certain what the value of info("system") returns on a Mac, I would probably invert this to simply use a check against that value rather than a "1 - " logic. If this is going to be used multiple times, it is probably best to do the info check and logical comparison only once, and then use the true/false result to offset by one row or not.Īnd then my reference to the pivot table cells contains: This function will offset by one row in case my operating system is NOT pcdos (i.e., on a Mac). Instead of referencing the cell directly, I now use offset(reference_cell, 1-(info("system")="pcdos",0) as the new reference to the cell. Then I created a reference to the cells I am using in other places. This equals "pcdos" (without the quotes) on my PC, and I have not yet been able to confirm the value on a Mac. use the function info("system") to return the system type.
#Does office 365 for mac have pivot Pc#
The workaround I have (which some might even characterize as a hack) is to first find out which system I am on (i.e., PC or Mac), and then using an offset of one row in the case where I am on a Mac. I was hoping to find an answer to this issue, but since I did not, I figured I'd find at least a workaround, and post that.Īs Karthik stated, there seems to be an extra row at the top of the pivot table that, when I have other cells referencing data within the pivot, it throws off the referencing to all subsequent data rows. I too have encountered this issue and it is more than an inconvenience to me since I am creating a simple data analysis tool in Windows, but it will be used by users that are on Macs.
0 kommentar(er)
