hi, I have made a chart of data which then has a trendline added to get a line of best fit. The x and y co- ordinates of the maximum of this trendline is the...

If I use the following formula: =IF(B25="","",B25+C25) in Column U all the way down to Row 20000 to create a new value... (Column B has a date and Column C...

I'm building a chart that uses multiple stacked bar charts to show an employees work time broken down into days of the week. I've read online, and downloaded...

I need to delink charts from their source data before posting the workbook on a network. Each worksheet has 8 charts. There are about 12 worksheets. There...

Question is for Excel 2000, running under Windows 2000. When you are working on a chart and the titles get out of center, is there any way to align them...

I have recently changed from Office 97 to Office 2002, and I've noticed that when updating a data range in a chart, I can no longer use my shift, control, and...

Is there a way to enter two rows of text in a single cell or row of cells?

Hello, I created a line column chart on 2 axis. I have four data sets. The first 3 should go on the primary Y axis as columns and the 4th should go on the...

Hi, I have a sheet that I need to make a stacked column chart from. The data looks like this A B C D 1:15 51 34 85 (with column d...

Why isn't there an Excel feature that allows the Y axis to scale, and the user to be able to select gridlines appropriately? For instance a data range from...

Hi, I'm required to do "waterfall" diagrams on a nearly daily basis at work. My employer likes to show development in numbers this way. I'm not even sure if...

I have a problem trying to programatically create a 3dLine chart, where it gives me a '1004' error when trying to set any properties of SeriesCollection(2). I...

Is it possible to create a bar chart type timeline in Excel. It would have tasks on the verticle axis and the timeline on the horizantal axis. The result would...

Can anyone help me create a broken bar chart? My boss wants to start using these charts in future presentations and I have no idea what they are. Thanks! Anna

After you enter your formula into F24 and press Enter, what appears in that cell? - Jon ------- Jon Peltier, Microsoft Excel...

Daniel - Leave the cells blank and Excel will break the line. Blank doesn't mean a formula that returns ""; this will plot like a zero. If you enter true...

Hi, I have the following data set Apr May Jun Jul Aug Sep 2002/03 491 233 2039 2146 292 2716 2003/04 2523 2261 1054 784 2267 41 What i want to do is have...

Is there a way to combine two sets of data with common X & Y axes on a scatter chart that lets the viewer see that there are two clusters of data (say with...