Create multiple Graphs on one sheet form one pivot table on another sheet
I need to create 25 different graphs (All on one sheet) from one Pivot table's data (different sheet), without the pivot table creating multiple different pivot tables. Also, the graphs need to update every month when the pivot table is updated. How is this possible? Currently all data are copied and pasted into different tables and then graphs created from each table. Thank you Kind regards Simone Fick
How to color-code points in a scatterplot by a third, non-quantitative data category
I have three columns of data. Two columns contain numerical data, which I want to plot on the x- and y-axis of a scatterplot. That part's easy. It's the next part that trips me up. I have a third column which contains categorical data. I want to use the values in this column to color-code all the "points" on the scatterplot. For example, in the attached screenshot, I would like the points in categories "A", "B", and "C" to each be assigned a color. I've tried a million things, but cannot for the life of me figure out how to do this. Any help would be much appreciated. Thank you!
Map Chart: Regions not displaying properly
I'm having problems getting a particular region to display properly in Map Charts. I'm not sure if it's region-specific or a problem with the programme. I'm pulling together a map of Georgia, the country, and a single region, Adjara, is not rendering properly. It doesn't render at all using many of its normal toponyms, and when spelled using the less-frequently used toponym "Adzharia", it appears as a thin sliver along the border. Any idea what's up? File attached.
Charts acting like blank cells are zeros - NB the cells use a formula which returns the blank value
Hi, I have a column, C, of the form: C6=IF(OR(A6="",B6=""),"",A6-B6) where A and B are columns with mostly numerical values but occasionally blanks. The formula, rather than a simple C=A-B, ensures C is also blank if either of A or B are blank. So my column C now has mostly numerical values but also some blanks. So when i look at Averages in the column the returned value is correct. HOWEVER, when i chart the row, all the blank cells appear as zero values in the chart. If I 'delete' the formula that gives the blank return, and therefore replace it with an empty (ie blank) cell then the chart treats it correctly as a gap. How do i get the chart to treat the blank (resulting from the formula) as a true blank (ie a gap in the chart)? Or do I need to change the formula?
