| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary Axis(X) Formating Issue
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
I couldn't reproduce your issue. What version of Excel are you using?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
2003, I'm assuming it's version 11.
Raul "Jon Peltier" wrote: I couldn't reproduce your issue. What version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
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!ScrollLabelsScrlngD AXChrt Second category (X) axis labels: =WaterQuality_KilnWTS_Data.xls!ScrollLabelsScrlngD AXChrt2 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 "Jon Peltier" wrote: I couldn't reproduce your issue. What version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
I was trying an example in 2003.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 2003, I'm assuming it's version 11. Raul "Jon Peltier" wrote: I couldn't reproduce your issue. What version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
I don't see any reason why these would matter.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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!ScrollLabelsScrlngD AXChrt Second category (X) axis labels: =WaterQuality_KilnWTS_Data.xls!ScrollLabelsScrlngD AXChrt2 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 "Jon Peltier" wrote: I couldn't reproduce your issue. What version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Primary Axis(X) Formating Issue
I didn't think it would either, but I'm at a loss for an explanation so
thought I'd mention it. Thanks, Raul "Jon Peltier" wrote: I don't see any reason why these would matter. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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!ScrollLabelsScrlngD AXChrt Second category (X) axis labels: =WaterQuality_KilnWTS_Data.xls!ScrollLabelsScrlngD AXChrt2 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 "Jon Peltier" wrote: I couldn't reproduce your issue. What version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raul" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Issue | Excel Worksheet Functions | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Memory or power issue | Excel Discussion (Misc queries) | |||
| Formating Issue | Excel Discussion (Misc queries) | |||
| Conditional Formating issue..... | Excel Worksheet Functions | |||
Linear Mode
