Custom list in a excel 2007 chart

  • Thread starter Use of a specific custom list in excel
  • Start date
U

Use of a specific custom list in excel

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.
 
S

Shane Devenshire

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.
 
U

Use of a specific custom list in excel

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 didn’t
receive the confirmation of my post. So I thought it was not been publish.


Shane Devenshire said:
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 said:
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.
 

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