Hi All...... I have a complex Workbook that uses a Report Sheet to bring in data from a internal Database Sheet to create a "report" and 3 small charts. The...

As header. Doesn't seem to be a facilility in Excel to do this. NB. This is not about 'radar graphs' - I need range and angle to be plotted.... TIA.

Hi - I have never used pivot tables in Excel before so hopefully what I am going to ask is possible and not too complicated for me.... :o) I am working...

I have a bar graph plotting Weighting 100% 90% 70% 20% 10% 9% 1% Grand Total Pipeline 2 21 19 39 4 1 10 96 I would like to centre...

somehow a dotted line with the words chart area in the lower right corner appeared around the chart area and I don't know how to get rid of it. I've tried...

I need to insert a shaded area to show if my data is falling between two points. I have 12 months on the axis and vertical numbers reflecting amounts done. I...

Is it possible to remove a series from a pie chart without the percentages of each pie section changing? I tried to hide rows in the spreadsheet that have 5...

I have Excel 2007 and when I click on a data series and select 'Add Data Labels' they don't show. Any ideas? -- Jerry

I have about 9 bell curves in a chart, 1 standard and 8 variances. They lie almost on top of each other and the chart is cluttered. I want to turn off 7 of...

I am using a simple chart to plot a range of values against weekly dates (Monday 5/01/2009 to Monday 28/12/2009) Excel inserts 3 dates before and after my...

This is not a question, just a place to record the answer to this question in case somebody else searches for it; or I forget again in the future. I wanted...

I am trying to create a chart where the (y) vertical axis is one metric (%) and the (x) horizontal axis is also scaled as a %... In other words I would like...

I need to creat a stacked column chart, but need the columns to be one in front of another, vs either stacked next to one another on top of one another. The...

How do I get Excel Charts into sharepoint?

I have a SharePoint dashboard consiisting of Web Parts with each displaying an Excel chart. These were created in Exel 2003 by publishing charts which are...

I am running Excel 2007 on a worksheet with about 450,000 data points. Every now and then I accidently hit F11 and Excel tries to chart the worksheet. Is...

With this version of excel, unlike the old one, I'm not able to modify in powerpoint a graph created in excel. Is there any solution, or I have to go back to...

How to create intersectionso if the hight of bar crosses that line the color of the bar should from that point. From Level 0 - 2:- RED Color From Level 2 -...

I am trying to format the tick marks on the horizontal axis as years, e.g., 2000, 2001, 2002 etc. This should be easy but none of the "canned" formats let...

Hi Folks, How do you change the horizontal axis labels (e.g., change the years used). It use to be so easy with XP. Thank you in advance