ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Custom list in a excel 2007 chart (https://www.excelbanter.com/excel-worksheet-functions/221181-custom-list-excel-2007-chart.html)

Use of a specific custom list in excel

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.

Shane Devenshire[_2_]

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.


Use of a specific custom list in excel

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.



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com