show in the data table but not plot on the graph

  • is it possible to have values of column show in the Data Table but Not on the graph.


    In the example attached, I would like the show


    On the graph:

    1- Pass and fail as clustered column

    2- Pass % as line

    3- NOT show total incidents


    On the data table:

    1- Pass and Fail number

    2- Incidents number

    3- NOT show pass %


    Thanks in advance


    Best'

    P

  • The short answer is no, data tables are limited in terms of what you can do with them. You could do something like setting up a range of cells with the data you want, then use the camera tool to put a linked picture of that range onto your chart instead of the data table.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!