Hi all, Wonder if you can help. I have a line chart with no of stations or a distance along the x axis and time along the y Axis. what ever i try including...

Having produced a trendline and have the equation displayed on the chart, is there any way of displaying that equation on the excel sheet itself. I need to...

I'm attempting to set up a dynamic chart. So far, I've defined a name for cells B33:M33 (using the following offset...

How can I stop a chart reformatting when I refresh a pivot table

I have about 15 worksheets with a separate chart embedded on each sheet. I'd like to run something in VBA (if available) to display the chart name and the...

Dear sirs, I know how to change the shape of a point in a chart in Excel 2003, but unfortunately you can only use squares, stars, ... . For experiments my...

Hi I have recently been impressed with the fitting of lines to many thousands of data points in Excel when displaying this information on a chart, and...

I am creating surface charts containing a lot of data and I'm using a colour scheme imported from another spreadsheet that looks nice and pretty and fades from...

Hi all, I am currently making a chart that needs to take its data from 1 of 2 series', depending on whether cell A1 contains the number 1 or 2. I tried to use...

I'm looking to build a variable data range to help in some charting. I've tried a few forumla/text combos and have had no luck thus far. I'm wondering what is...

Each time I save an Excel File, the following message appears and I want to disable it. The file may have been changed by another user since you last saved...

I am trying to plot two values for each day on a line chart. I have followed procedures that I have used in other line charts that is clicking on the range of...

For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a line graph, is there anyway to make them spaced apart so that they are in scale...

Sheet1 was populated with column arrays in Range("A8:J50"). I wanted to creat a chart for column array as specified in cells A1, A2, A3 as rowbegin, rowend,and...

How can I keep an excel chart from plotting a blank cell as zero? I am plotting a series of numbers, each month. If the month is not here yet, then that cell...

Can I create a chart that delineates any row I choose without creating a new chart each time? The data I want to chart resides in columns B through BD and...

after I have worked on the excel spreadsheet which has 8 columns and approx. 72 lines. Then I go in to print and the page setup is at 15, when I go to change...

I would like to create a swing chart (stock chart) with a dynamic range that grows as more data is added. Any ideas? Thank You Joe

Hi guys and girls(i'm told there are a few of you out there), I have seen posted on MSDN that the Text property can not be set on a shape via VBA using excel...