Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Custom list in a excel 2007 chart

Hi
How do I do use my specific custom list in excel 2007 chart, I created,
instead of the default custom list. That is related with the presentation of
the days of the week. There are 2 presentations: the default one and the one
I created. I am not enabling to force Excel to use my custom list. I think
that the Visual Basic of both lists are equal, that is €œ[$-F800]dddd, mmmm
dd, aaaa€, without quotation marks.
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Custom list in a excel 2007 chart

This is a repeat of the answer you recieved a number of days ago. Custom
Lists are not related to Formats. You are showing us a custom format, what
does your custom list look like?

What do you think the default custom list is in Excel? Please show us.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Use of a specific custom list in excel" wrote:

Hi
How do I do use my specific custom list in excel 2007 chart, I created,
instead of the default custom list. That is related with the presentation of
the days of the week. There are 2 presentations: the default one and the one
I created. I am not enabling to force Excel to use my custom list. I think
that the Visual Basic of both lists are equal, that is €œ[$-F800]dddd, mmmm
dd, aaaa€, without quotation marks.
Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Custom list in a excel 2007 chart

Ok. I have two (not only one as I said before) default custom lists,
representing both, in Portuguese, the days of the week:
The first one: €œSeg, Ter, Qua, Qui, Sex, SĂĄb, Dom€;
The second one: €œSegunda-feira, Terça-feira, Quarta-feira, Quinta-feira,
Sexta-feira, SĂĄbado, Domingo€.

I created a new custom list that also represents the days of the week:
€œ2ÂȘ-feira, 3 ÂȘ-feira, 4 ÂȘ-feira, 5ÂȘ-feira, 6 ÂȘ-feira, SĂĄb, Dom€.

When I created a Excel chart, the labels that are in the data, in my custom
list format changes and shows like the second default custom list I indicated
before.

So how do I do to force Excel to respect the previous format of the chart
data?

Thanks.

p.s. - Sorry I wrote the same question more than once because I didnt
receive the confirmation of my post. So I thought it was not been publish.


"Shane Devenshire" wrote:

This is a repeat of the answer you recieved a number of days ago. Custom
Lists are not related to Formats. You are showing us a custom format, what
does your custom list look like?

What do you think the default custom list is in Excel? Please show us.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Use of a specific custom list in excel" wrote:

Hi
How do I do use my specific custom list in excel 2007 chart, I created,
instead of the default custom list. That is related with the presentation of
the days of the week. There are 2 presentations: the default one and the one
I created. I am not enabling to force Excel to use my custom list. I think
that the Visual Basic of both lists are equal, that is €œ[$-F800]dddd, mmmm
dd, aaaa€, without quotation marks.
Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom list in a excel 2007 chart Use of a specific custom list in excel Excel Worksheet Functions 1 February 12th 09 05:42 PM
Specific custom list in a excel 2007 chart Use of a specific custom list in excel Excel Worksheet Functions 1 February 12th 09 01:44 PM
Specific custom list in excel 2007 chart Use of a specific custom list in excel Excel Worksheet Functions 0 February 12th 09 10:17 AM
Specific custom list in a excel 2007 chart Use of a specific custom list in excel Excel Worksheet Functions 0 February 12th 09 10:13 AM
How to force the use of a specific custom list in a excel 2007 cha velasques Excel Worksheet Functions 1 February 11th 09 09:00 PM


All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"