How come when I try to insert a chart in Excel, nothing happens? Hi. In Excel 2007, I am unable to insert a chart. I select a range of cells, go to the insert tab, select Column in the charts group and "clustered column" (or any different type of graph such as a line graph), hit click and nothing happens. To test this issue, I tried to download a chart template from Microsof... 30 Mar 2010 13:54
print message Is it possible to conditionally format a chart so that it prints a message-like "out of range"-when source data on the y-axis falls outside a range? -- stan ... 31 Mar 2010 12:08
Text-wrapping horizontal axis labels Hi, I've a small problem which I can't seem to find a solution for - I have created a set of financial reports for a client, which includes a number of charts. The charts are waterfall charts, which I've constructed using a form of stacked bar chart. The labels for the horizontal axis are linked to text alo... 30 Mar 2010 08:20
Blank instead of "" Hi, In a chart I have a formula that either returns a number or "" in a cell. I then have a dynamic range set which plots the values on a graph. The problem is that the chart will plot the ""s as zeros as it sees something in the cell. Is there a way I can have a true blank cell result coming from a formula... 30 Mar 2010 19:35
Grouping dates on a chart I have a workbook with 12 sheets in it, one for each month of the year. Each sheet has the day of the week in column B, several other values in columns C -- J and a transaction value in column K. What I want to do is create a chart that groups the dates into days of the week and then displays a bar showing the su... 30 Mar 2010 19:35
Can't change pt. size in a 3-D Format Chart For some reason, I am not able to change the width and height point sizes when I am trying to apply 3-D formatting to a chart in Excel. I try to type the numbers in, but the pt size just defaults back to 0. My husband thought it may have been a stuck number key somewhere, so I turned the computer off and reboot... 29 Mar 2010 13:39
Fix poor image quality when pasting from excel to powerpoint? How do I get around the poor image quality when pasting from excel to powerpoint? ... 29 Mar 2010 13:39
Anchoring Phase Change Lines How do you anchor phase change lines or text boxes to the horizontal axis so that, as you add additional data, they maintain their position relative to the horizontal axis when the chart is redrawn with the additional data? ... 29 Mar 2010 04:46
Sorting PivotChart data Hi, In excel 2007 I want to sort data in the chart I made from pivot. I want them to be sort in descending order. The reason is, I need bar Pivotchart diagram to use as Pareto chart. I'm also using this new function in excel 2007 , "drill-down" or "drop-down" to multiple levels/layers in PivotChart. I want als... 27 Mar 2010 06:55
Excel 2007 - How can I switch the data on vertical and horizontal I'm using Excel 2007 and would like to know how to switch the way the data shows up on the chart. I would like to have the information that is being plotted on the vertical axis on the horizontal axis instead and visa versa. Thanks for any help. ... 26 Mar 2010 14:22 |