How to include variance data in the chart table but not on the gra

J

Jeremy Clarke

Does anyone know how to include extra data in the graph table that is
attached to the graph, without actually plotting this extra data on the
graph?

For eg. i'm trying to include variance % data in the chart table but I don't
want this to be plotted. This is because some of the variances are negative
and I don't want this to detract from the overall impact of the graph.

Any help greatly appreciated.

thanks
Jeremy
 
J

Jeremy Clarke

Thanks Andy that's helpful. I've placed the variance data on the secondary
axis. How do I format the secondary axis to not display? I do however want
the variance data to display in the data table.
 

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

Similar Threads

graph variance components when 1 is negative 4
Totals in the data table but not in the graph / chart 1
Remove a column but not data table entry 4
Include info from data source in data table but not in chart 1
Chart Certain Data in Table 2
Chart Certain Table Data 1
Co-ordinates plotting on Graph //sk 1
Display Data Table in chart but don't show plot area 2

Top