Can You Use Defined Names in Source Data Dialog?

  • Thread starter Thread starter Julia Ouellette
  • Start date Start date
J

Julia Ouellette

Hello,

I've got multiple graphs that are all using the same x-
axis category labels ("99", "00", "01", etc.). I was
trying to set up a way so that each graph's s-axis
category labels come from either one cell or a defined
name. No matter what I do though, it won't work, and I
only have two options:

1. enter "99", "00", "01", etc as the category labels for
each graph in the source data dialog box; or

2. select a range of cells where each cell contains the
value, i.e., "99" is in cell A1, "00" is in cell A2, etc.
This is what I'm doing now, but it's more frustrating than
it should be, I think.

Would be great if I could put the text in one cell
("99", "00", "01", etc.) and then just refer to that for
the category labels.

Is there another way to do what I'm doing? Thanks for any
assistance,

Julia Ouellette
 
Assuming you have a chart other than a XY Scatter chart or a Line chart
with the x-axis as Time values...

The easiest way would be to put the *text* values in some column and
specify that column as the source for the x-values of the plotted
series. XL will label the x-axis with the contents of the specified
column.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Julia -

You can define a name, MyArray, and put something like this into the
Refers To box:

={"99","00","01"}

In the Series tab of the Source Data dialog (in the chart wizard or from
the chart menu on an existing chart), you can select a cell range for
the Y values, and for the category labels use:

=Sheet1!MyArray

You need to prefix the sheet or workbook name before the range name.

- Jon
 
Back
Top