I've searched the archives but can find nothing on this topic. Prior to excel 2007, I could select a data series (xy scatter chart) and press the right arrow...

The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389("09/01/07"+0)),--('Filled...

Can I ask in a formula to not add a number in an array of a certain colour until the colour is changed. eg unpaid is in red, when paid change to black.

I'm trying to graph the function sin(x) in radians and I want my x-axis to list the standard "pi/2; pi; 3pi/2; and 2 pi" but I can't figure out how to do it...

I need a graph which has a combination of horizontal bars (could do vertical as well, though doubt it matters for whether this can be done), where for each...

To all, I have a workbook with multiple worksheets labelled data1, data2, data3, and data4. I also have one sheet called 'graph'. On worksheet labelled...

Hi, I have three columns of data: watershed name, acres of original old growth and, % loss of old growth acres. I created a scatter plot that displays the...

All, I am having difficulty programmatically changing chart parameters. For instance, I want to modify the PlotArea.Height of one of my charts. When I resize...

To all, I have a xy chart in excel. Is there anyway by writing a macro, that the user can click on two points on the graph, and then it calculates the...

I have created a line graph in Excel (with my input data on a separate worksheet). I have 3 columns: Planned, Actual, and New. I am tracking 'requirements'...

Hi, I'm trying to format a bar chart which has promotions on the y axis and i would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08 and so...

I have a chart that shows change in blood pressure over time. I would like to mark on the graph certain key dates (x values), for example where diet...

I have created a workbook to track daily/monthly production and efficiency data. I have each day of the month as a new worksheet and corresponding tab. Now...

I'm trying to create a graph where my X Axis list various contries. For some reason my X axis is reading as numbers instead of countries. The source data is...

Dear Group, Hello. I recently posted a question related to the issue of putting a mu (µ) symbol into MS Excel charts. Someone kindly suggested using the...

Hello, I have a set of data I wish to graph in a scatterplot. Each data point has two identification codes, coming from two separate groups, e.g., L = ...

I know this is simple, but I cannot remember how. I want to copy a chart into another worksheet, but do not want to keep the links, just the picture and data...

Hi, I need to add only vertical error bars to a single data point in a series on a scatter chart in Excel 2007....

Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the...

I have an idea for a chart type that I can almost construct in Excel, except that I am frustrated by the fact that Excel columns have only a single option for...