First of all, I'm not sure if I should post this question in "Charts" or "General" or another topic, but I have a workbook that has been around for a few...

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"...

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...

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...

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...

Hi I have some data with the first column as simply the item #. I want this to be the x axis of my chart. The first series I want to chart is in the 4th...

Hi, I have no luck looking through the JPelltier website or other such sites so can some-one please give me a clear indication of how I can change this. My...

I created a cluster-stacked column line chart on a Windows machine (Excel 2003) and sent the file to a user on a Macintosh. When the file was opened on the...

Hi, On an XY scatter chart, how can I have two sets of intervals for the Y axis without doing a secondary scale? My data varies greatly and does not show...

I have 6 bars i would like to graph I could get the 6 bars, but I want to separate them into two groups of three. Essentially a blank column in the...

would like to know when to use the Extract shape in flow chart?

I'm trying to display a line graph and I'd like to remove a single point. Using "" or "0" in the calcs sends the line graph to zero a that point. Is there a...

I want to drag and paste a formulea across a row. But the formulea takes information from another cell, then will miss two columns out, and themn takes...

Hello, MS EXCEL 2003 on XP PRO. I have a stacked column chart and I want to throw cumulative data labels on it. If I go into Chart Options and turn on the...

In Excel 2007, the line and scatter charts do not display the correct x,y values when the cursor is hovered over a data point. Excel 2003 displayed the...

Hello and thanks for the help. I am using Office 2007. I have a sheet with 8 people listed and their sales. Here is a brief example: Rep Jan Feb Mar JO ...

I have the following data in Excel: Total Percentage Product 1 7 28% Product 2 18 72% Total 25 100% I want to represent all data in a pie chart,...

I want to change the background color of my chart and to do that I either click on the button on my toolbar with the little paint bucket or I right-click...

How do you combine a scatter plot (showing numbers on axis) with a category plot (showing categories) and a line graph that is within the area of the...

Have a column chart in which the same label applies to two adjacent columns. Rather than have it redundantly redisplay the labels I adjusted the tick mark...