Primary Axis(X) Formating Issue

R

Raul

I'm using a custom type chart (Lines on 2 Axes) and I'm using two different
ranges for the Category (X) axis labels and the Second category (X) axis
labels in order to display some additional information on the chart. When I
say two different ranges I mean the rows are the same, but the columns are
different.

The problem I'm having is I want to use a custom format (dd-MMM-yy) to
display the dates, but when I do so the dates have format MMM-yy-dd. The
only way I can get the dates to display accurately is to use the Date format
with the * (either *03/14/01 or *March 14, 2001).

By the way, I don't have any trouble using the "dd-MMM-yy" format if the
Category (X) axis labels and the Second category (X) axis labels refer to the
same range.

Does anyone have an explanation as to why I can't get the desired format
for the dates when the Category (X) axis labels and the Second category (X)
axis labels refer to different ranges (rows are the same, columns are
different)?

Thanks in advance,
Raul
 
J

Jon Peltier

I couldn't reproduce your issue. What version of Excel are you using?

- Jon
 
R

Raul

I failed to mention that I'm using named ranges in the charts and the named
ranges use the offset function.

Category (X) axis labels:
=WaterQuality_KilnWTS_Data.xls!ScrollLabelsScrlngDAXChrt

Second category (X) axis labels:
=WaterQuality_KilnWTS_Data.xls!ScrollLabelsScrlngDAXChrt2

ScrollLabelsScrlngDAXChrt:
=OFFSET(All_Data!$AJ$5, ScrlngDAXChrt!$B$2,0,ScrlngDAXChrt!$B$3,1)

ScrollLabelsScrlngDAXChrt2:
=OFFSET(All_Data!$AI$5, ScrlngDAXChrt!$B$2,0,ScrlngDAXChrt!$B$3,1)

Sorry,
Raul
 
R

Raul

I didn't think it would either, but I'm at a loss for an explanation so
thought I'd mention it.

Thanks,
Raul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top