Creating Sankey Diagrams
Hi, Does anyone have any guides for creating Sankey Diagrams in Excel. I deal with the analysis of a reasonably long process which has various customer inputs and outcomes. I am looking for a visual way to show everyone who came into the process, and what happened to each person. Sankey Diagrams seem to fit that bill perfectly. Any help would be appreciated. Thanks T
Converting excel data into a printable calendar template
My work runs about 200 events per year. These are listed in an excel spreadsheet. However they also have a word template which has the layout of an annual calendar. This means there are months across the top, and dates down the left hand side (like those big annual calendars you see on a noticeboard). Everytime they add an event or edit an event, it has to be done in the excel spreadsheet manually, and then go into the word spreadsheet manually. I am wondering if there is a way to update it in excel and it magically links to a template (or app) that has the look of a wall calendar. It seems there is a lot double handling and opportunity to make mistakes. Thanks Tammy
Button for reset all filters
Hi, First of all I am not at good at this but I looking for a way to use a button to reset all the filters I have. To use one button instead of clear all the filters separately would be great as it is more effcient. But as I wrote, I am not very good at this I was wondering if someone could show/teach me how to do it.why text values are not converting to numbers
Hello guys I have a file with values that are text, am trying to convert it using methods like 1. =value (text) 2. multiply by 1 3. using paste special multiply by 1 etc, but still all methods are not working its really strange never happened to me before anyone knows what is the issue?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?
Make sentence from data in cells in Excel
Hi, I have a form of 4 cells (as you can see in the attached picture) & I need to get the values within brackets of the sentence filled when updating data in A2, B2, C2 & D2. Please be kind enough to share a code with me to get this done ASAP. Thank in advance!
