-
Hello, when I try to apply saved chart type for a chart based on a pivot table, it doesn’t apply the chart type. I think it is a Microsoft bug, since I do manage to apply the expected chart type on charts that are not based on pivots. any solution for it? thanks
-
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...
-
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...
-
I have found the following link (http://peltiertech.com/Excel/Charts/BarLineCombo.html) which has shown me how to create the chart I want, however I would like to increase the number of bars from 5 to 32 for my application. In doing so though I have noticed the alignment of the bars and lines becomes...
-
Welcome to the Charts Forum You should post any questions on charting within Excel here. Have fun