none
Why is a chart using the y axis also as a label? RRS feed

Answers

  • Dave,

    from [MS-OI29500]:

    2.1.1548 Part 1 Section 21.2.2.227, varyColors (Vary Colors by Point)

    a.  The standard states that each point shall have a different color.
    In Office, this element also specifies that marker types shall vary by point

    ...

    d.  The standard does not state any exceptions as to when the vary colors by point is applied.
    Office ignores this element and does not vary colors by point when multiple series are specified on
    the chart.

    This is what is causing the color and marker type rendering you see in the two charts.  In both charts, varyColors is 1 but good chart has multiple series and bad has one.

    Tom

    Tuesday, June 19, 2012 2:15 PM
    Moderator

All replies

  • Hi David

    Thanks for contacting Microsoft Support. One of our engineers will follow up with you shortly.

    Thanks.


    Tarun Chopra | Escalation Engineer | Open Specifications Support Team

    Wednesday, June 6, 2012 4:36 PM
  • Hi Dave,

    I'll look into this and get back to you.  Also, can you please start adding document and specific section number(s) to your posts?  Even adding the higher level section where the subject should be covered (e.g. for DML Charts, 21.2, 21.2.2, etc...) would help when triaging the issues. 

    Best regards,
    Tom Jebo
    Escalation Engineer
    Microsoft Open Specifications

    Thursday, June 7, 2012 2:34 PM
    Moderator
  • Hi Tom;

    Yes, happy to add that. Can you point me to the latest revision of the spec so that I am using the correct section numbers? Preferable in indexed PDF form we can download.

    thanks - dave


    Who will win The International Collegiate Programming Championships?

    Thursday, June 7, 2012 2:39 PM
  • Go to http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=51463 and click on the hyperlinked word "downloaded" in the note paragraph:

    Note: The electronic version of this International
    Standard can be downloaded from the ISO/IEC Information Technology Task Force
    (ITTF) web site

    Then, go to the bottom of the page and you'll see the 2nd edition links for all four parts (i.e. ISO/IEC 29500-1:2011).

    Tom

    Thursday, June 7, 2012 2:47 PM
    Moderator
  • Dave,

    from [MS-OI29500]:

    2.1.1548 Part 1 Section 21.2.2.227, varyColors (Vary Colors by Point)

    a.  The standard states that each point shall have a different color.
    In Office, this element also specifies that marker types shall vary by point

    ...

    d.  The standard does not state any exceptions as to when the vary colors by point is applied.
    Office ignores this element and does not vary colors by point when multiple series are specified on
    the chart.

    This is what is causing the color and marker type rendering you see in the two charts.  In both charts, varyColors is 1 but good chart has multiple series and bad has one.

    Tom

    Tuesday, June 19, 2012 2:15 PM
    Moderator
  • Hi Tom;

    That must have been a challenge to find - thank you very much.

    thanks - dave


    Who will win The International Collegiate Programming Championships?

    Tuesday, June 19, 2012 5:56 PM