Hi there, I'm trying to graph stock price data vs. date, but whenever I graph the two on an area or line graph, excel (2000) automatically adds in the missing...

Hello. I need some help figuring how to accomplish this task: I have two sets of y-axis values that are under the same set of x-axis value. I am using one set...

I am using the following code in ThisWorkbook: Private Sub Workbook_Deactivate() MsgBox "Deactivating Workbook" End Sub This works fine in most cases....

I'm trying to draw a line graph where the X-axis is represented by date and time. From the left to right, my points go from 20-seconds apart to 5-minutes...

Any ideas?

I have the data series in order and the legend entries follow this, but I now see that the legend text is not in the good alphabetic & datewise order I wish. ...

I am using the same data that Darell posted...since what I want is similar yet.... I have 20 departments with 4 regional managers looking after...

A spreadsheet is showing the column headers in numbers. How can I change them back to letters?

How do I put a straight average line (previous years' average) on a bar chart that also has a trendline?

Hello, I have a table that has formulas such as the following in it: =IF($L21NewStats!$B$47,"",SUM(B$8:B21)) The table keeps a running total based on...

With ACCESS data downloaded unto EXCEL, how many columns of data can used on a PivotTable and PivotChart? How do I do it?

Hi, my data in the Y-axis is a string value, but it doesn't Excel chart won't accept that. It interptets all the string values as 0. If I put a integer value...

Hi, I'm trying to build an XY Scatter Graph. I want to have: * "Opportunity" on the Y axis * "Capabilities" on the X axis * I'd like to have each XY...

I know that you can paste a picture (e.g. a picture of a pen) into the Column of a Column chart by either simply copying/pasting the picture or as a...

Hey there, I am trying to plot specific values on the X and Y axis and when I use the chart wizard it creates two lines with the Y values being generic...

I want to generate surface plots of the form (x,y,f(x,y)). Should I just go buy MathCAD, or can Excel manage this?

I have a zoom feature for my chart. There is a spinner on my chart, so when i increase or decrease the value of the spinner, a macro executes and assigns new...

I have a single series which is charted each month and want to automatically format one of the points (a bar) a different colour. Is it possible to do this...

I am in the process of converting Lotus 1-2-3 spreadsheets which have charts in them to Excel. After starting Excel and opening the Lotus file in Excel. I do a...