1
vote
2answers
521 views

In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart: Looks ok, but the X-axis is ugly, so lets clean that ...
1
vote
2answers
350 views

Changing the axis labelling in a Excel 2010 scatter plot

I am trying to represent a list of data points in such a way that the graph starts at X coordinate '1' but that labelling starts at coordinate '100' and I have been unable to find out how to do it as ...
3
votes
1answer
9k views

How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set: Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | ...
0
votes
3answers
373 views

How to create label on chart containing contents from a cell on another sheet?

Simple problem. I have a chart in Excel and some text data on a sheet. I want to create labels on the chart that reference text on another sheet. I want to be able to update the text and have the ...