On Wed, 18 Apr 2007, in microsoft.public.excel.charting,
Jeff Rasnick said:
Sorry if the subject is not very explanitory, wasn't sure how to word it.
Basically my issue is I am trying to create some different charts from a
spreadsheet where there might be multiple rows for the same values that will
go on the X axis. For example this spreadsheet might have the following
Data:

ABC Company $500
BCD Company $332
XYZ Company $500
XYZ Company $200

It's tricky, because what you'd like is to use the XY chart (Scatter
chart) type instead of a line chart, which as you've observed, treats
each row as a new category on the Category axis. You want the X axis to
be an interval scale, not a category scale. The problem is that
intervals need numbers, not words, so to start with, you have to have
data that looks like this:

1 $500
2 $332
3 $500
3 $200

Now the chart will look right, but how do you ensure that the company
names have a matching number? I always use a separate lookup table, and
then the VLOOKUP() formula to determine the numbers.

Then, once you've used the numbers to make the scale, you have to put
the words back in to provide a labelled X axis. How? You can use the
Dummy series method as shown by Jon Peltier or Tushar Mehta:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://www.tushar-mehta.com/excel/ne...ble_log_scale/

This is a lot of trouble to go to, but the graph type you are trying to
design is often worth it. It's a type I design frequently.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.