Is it possible to create a stacked Column and line axis Chart? Stacked column from 3 rows of data. & Line from 1 row of data?

Hi all, a quick question. i have a scatter graph that graphs a correlation of scores over 2 weeks. x axis is score for week 1, y axis the score for week 2. if...

I have a bar graph that charts 4 regions: east, west, north, south. Beneath it, I have a data table with the counts for those regions. I also have the total...

Simple (but frustrating) problem for Excel-2000: When adding a series to a xy-scatter or column chart, the only way to select a new data range (x or y...

hello dudes, i am trying to graph say shoe sales by week, i'd like to include a trendline and the trendline plus and minus the standard deviation. is it...

I am running Excel 2000 and Windows XP. When I generate a scatter plot and attempt to re-format the y-axis title, the active text box excludes some of the...

Can Excel do most things a stats program can do? E.g. SPSS, SAS? Sum of squares easy to use? Can a reasonably small number of covariates be used without...

I have a line chart with perchantages as my Y-axis. What I need help with is addind a bold line to indicate what the target perchantage is.

How can I quickly get an index column running from 1 to (end of data)? I need this for sorting spacey data and getting rid of the blank lines. Then I restore...

I have a chart series which is based upon cells in more than 1 line, some of the cells in the series have #n/a (using an if to force #n/a if the cell value is...

I’m creating macros to help me reformat all the charts in a workbook full of charts and I have a few questions. Ill post them separately to keep the treads...

Use the chart wizard to create the chart, with one Y axis Right-click on the series that you want on the second axis Choose 'Format Data Series' Select the...

Hi, I need to make a chart that wil consist out of two series. The first one should be shown as a column, while the second as a line drawn on the given height...

I am using XLFIT4 (software that adds some functionality to MS EXCEL) for plotting a graph with x, y and z values. XLFIT plots the curve in 3D space., but I...

i need to change the percent in my excel sheet from 12% to 14%. i am entering in salesman's commissions, when i enter them, we have it calculated to total 12%...

I have a spreadsheet that I'm using to create a line chart. It is to show daily efficiencies. I've picked the new cell each day to add to the chart and it's...

I have a query that returns weekly data from an external source, covering a number of years, in tabular form eg. Year Tonnes Energy 1998 1000 ...

Allen - Why do you need the XY coordinates? Often there are easier ways to get what you want. To get some relevant dimensions in the chart, check out the...

OK here's the problem. I have a multipage Excel spreadsheet with a consolidation chart page at the end. The chart page grabs data from individual store pages...

Hello, I'm trying to make a chart from a pivot table, but only from certain colunms within that table. Therefore I made a second table next to it that just...