443483_es-ES

liliconcom

¿Cómo modificar marcadores en líneas / curvas similares a Excel?

Hola,
Estoy creando los siguientes gráficos a través del generador de gráficos y me preguntaba si me permitiría modificar algunos marcadores en líneas.

Por ejemplo

c1 triángulo inferior azul sólido -> Línea azul sólida.

c2 triángulo inferior azul hueco -> Línea azul discontinua.

c3 círculo verde sólido-> Línea verde sólida.

c4 triángulo superior rojo sólido-> Línea roja sólida.

c5 triángulo superior rojo hueco-> Línea roja discontinua.

Los círculos grises y otros símbolos permanecen iguales.

 

Probé la línea (x, y, leyenda (11)) en lugar de puntos (x, y, leyenda (11)) pero eso solo trazó la media de todos los datos.

Intenté Ajustar cada valor a través de un gráfico bivariado, pero no puedo generar este gráfico compuesto que traza varios de ellos agrupados por x2.

 

 

 

 

 

Graph Builder(
    Size( 1395, 3390 ),
    Show Control Panel( 0 ),
    Variables( X( :x1 ), Y( :z ), Page( :x3 ), Group X( :x2 ) ),
    Elements( Points( X, Y, Legend( 11 ) ) ),
    SendToReport(
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 2 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 3 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 4 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 5 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 6 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 7 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 8 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 9 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 10 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "ldrawn",
            ScaleBox( 11 ),
            {Scale( "Log" ), Format( "Best", 6 ), Min( 1.8 ), Max( 250 ), Inc( 1 ),
            Minor Ticks( 1 ), Label Row(
                {Major Grid Line Color( -15658734 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 2 ),
            {Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ), Minor Ticks( 0 ),
            Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 3 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 4 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 6 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 7 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 8 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 9 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 10 ),
            {Format( "Fixed Dec", 12, 1 ), Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ),
            Minor Ticks( 0 ), Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        ),
        Dispatch(
            {},
            "z",
            ScaleBox( 11 ),
            {Min( 0.0 ), Max( 0.56 ), Inc( 0.1 ), Minor Ticks( 0 ),
            Label Row(
                {Major Grid Line Color( -15921906 ), Show Major Grid( 1 ),
                Show Minor Grid( 1 )}
            )}
        )
    )
);

GráficosScriptingRe: ¿Cómo modificar marcadores en líneas / curvas similares a Excel?

Hola,

No estoy seguro de haber entendido su pregunta, pero podría ser tan simple como desactivar la visualización del gráfico de dispersión (primer icono del menú superior desde la izquierda) y activar la visualización de línea (menú superior, sexto icono desde la izquierda).

Mejor,

TS

Re: ¿Cómo modificar marcadores en líneas/curvas similares a Excel?

Y si mantiene presionada la tecla Mayús mientras selecciona el elemento de línea, tendrá tanto puntos como líneas.