Just found what looks like a bug with charts in Excel 2007. In Excel 2003 I could add a text box to a chart and then assign a formula to it, say =B30. The...

I have an xy scatter chart, which is plotting info for 3 different series. My end date is 2006, yet the X axis shows an end date of 2008. I have not...

I have a spreadsheet that totals errors for every employee daily and then sums them by month and year to date. Instead of having 13 charts (1 for each month...

I have a spreadsheet that totals errors for every employee daily and then sums them by month and year to date. Instead of having 13 charts (1 for each month...

How do you justify the text of an axis in an excel chart?

I want my graph to appear as 10^-1 and so on. Everytime I try to graph it, it converts it to something else. Could someone help fix this problem.

Hi, I have made a pivot chart and one of the "report filter" is "country" and I can select "ALL" or "multiple countries". Question: Is it possiple - in the...

I have created multiple pie charts that are not displaying correct percentages. For instance I key in 100 in one cell and 50 in the next cell. I create the...

I would like the categorical info to be displayed vertically and the value axis to be displayed horizontally. Is there any way around it?

I would like to create a combination chart with three chart types: 1. line chart to show month to month accum total growth for the year. 2. a single bar for...

how do I link chart to a cell that has text and numerics but the numeric dollar value being picked up does not show the separators and $ sign?

I want to create a chart, put it up on a webpage and when I update the data I want it to update the chart and update the chart on the webpage. I've used...

I am using a dynamic range to plot a chart area (using various charts). The dynamic named range data I'm using contains zero values/blank cells. How can I...

On the "READY" bar, what does NUM mean?

I am trying to color the series in my graph based on conditionally formatted cells is this possible? i have managed to automatically changed the color of my...

I've learnt a lot from the articles on dynamic chart ranges using named ranges and offsets. My problem is a little different, in 2 parts: a) My spreadsheet...

Im trying to create a chart that uses just the data that I enter, not a range. For example, I have part numbers like 717000, 717003, 717009. I don't want...

I need to have a linegraph where the X axis has the dates of, say, Oct 1, Oct2, Oct 3 AND Oct 7, Oct 8, Oct 9. My issue is that whenever I try to set the...

Please could you explain how I would highlight by changing the colour/fill of one bar in a column chart so that it stands out from the rest of the data...

In an excel spreadsheet, I have a series of data. Each "batch" of data has 24 cells, but there are only 2 cells out of each 24 whose values I want to plot on...