I have a project involving a hiking trail where I am trying to capture
altitude on Y axis versus mile marker location on X axis.   I can enter the
data in adjoining columns and use the chart wizard but each mile marker value
gets positioned along the X axis in uniform increments ...

I have a worksheet with a number of datasets. The datasets are all 360 rows
long and 2 columns wide. I wanted to plot the first set of data on a chart,
then the chart should find the next set of data, plot that, then the next. So
at the end i should have One chart containing ...

Is it possible to change the number of Column and Lines? I have a requirement
to have 1  column & 3 lines and the chart keep defaulting to 2 line, 2
columns. I am using the Excel 2003 and the chart type is (Custom Types) Line
- Column.

I have a chart that has the date across the bottom (category axis) and the
data up the side (value axis).  I want to change these.  Is this possible?

The following error appears evey time I click on a graph to change something
such as source data, add/remove series etc. I have to press ok a few times
before I can make the changes, but the error keeps on appearing.
Does anyone know why this is happening and how can it be solved?

Hi,
i have an excel workbook with quite a few charts in it. All the data for the
charts is stored on one sheet, is there a way of creating a hyperlink for
each set of data to the relevent chart? I dont fancy doing buttons for every

I have data in 5 columns, 20 rows.  Column A is salesman, Columns B-E are
things like sales quota, monthly sales, salray, etc.
If I sort Column B and then create a chart using columns A and B my chart
will show the columns in order of least to greatest value.  But then if I

I'm trying to do a line chart, and show the monthly movement on the lines to
go from the top of the chart, down to the bottom, rather than left to right.  
I cannot see how to achieve this, I think it may be a case of transposing
axis around but am not sure? - can anyone help.

I have a chart that uses a log scale on the X axis. The axis values range
from 0.1 to 100. I'd like to have them displayed as 0.1, 1, 10, and 100
(i.e., any number greater than or equal to 1 should not display any
decimals). If I specify 0 decimals then the 0.1 displays only as 0; ...

I've literally been searching through these posts for days and can't see to
find a direct answer to my question...so I'm hoping someone can help.
I have a simple column chart that is displayed on a worksheet with the
related data directly above it.  It contains about 8 months ...

How do i add a data label for my y-axis on a line graph created in word?

I've got a sheet that contains 4 graphs -- the graphs are already
built and update fine.  Rather than have 4 small graphs or make users
switch sheets, I want to use a spin-button to let them scroll through
the graphs.

I want to show two data series: Sum of Turnovers and Sum of Turnover Assets
in the pivot table simultaneously in the pivot chart. When I use a line
chart, the data points from two series are just connected into one line. Even
if I select Chart Type to be Line with Two Axises, it ...

Hi! I have a normal line chart. The data is in a matrix. My data is on an
annual basis. I want the chart to show discreet jumps in the line but xl
somehow manages to make them not show a vertical jump but it is a gradually
shift. this is regardless of which chart i choose. how ...

I found how to create a second x-axis thanks to this site...but the second
(upper) x-axis shows no values. The 'Value (x-axis)' window refers to the
primary axis.
How to fix this and show a scale with values?