-
We need to summarize a survey where a large number of items were ranked on a scale of 1 to 10. The survey folks sent me a table (in MS Word), showing the number of respondents who chose each value, and the average. E.g., for item 1, the table may list that 3 respondents ranked it as 1, 6 respondents...
-
I need to insert a line in a chart based upon the average of a data range. The line must reflect an average that will change on a daily basis.
-
Duncan, I have attached a file that shows one way to do this. It involves clicking a button on the spreadsheet, but you could move it to a worksheet_change event. You could also edit the code to add a variable start date as well. Code for the button is: Sub VariableChartRange() Dim dateEndDate As Date...
-
I need some help. I have 500 data points and I would like to create a bell shaped graph. Can someone please show me a step by step guide how to do this. my email address is vanse@hotmail.co.uk I can send you the data points if required. I've tried using the guide on google, but the instruction are...
-
I have a workbook in which I want to place two different graphs (each on its own page, and created with the Graph Wizard) from a second workbook. How can I do this? Excel automatically places the same graph twice and if I switch the second graph to the one I want then the first one gets switched too...
-
Hello all. I’m trying to duplicate a bubble chart using ellipses and I need a formula to calculate the size of them. I have calculated this formula: ES = Square Root (BS / (1-cte)) Where: ES - Ellipse size. BS - Bubble size. cte = Maximum value of the chart bubbles / -12000. Apparently the formula works...
-
Welcome to the Charts Forum You should post any questions on charting within Excel here. Have fun