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

Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
graph variance components when 1 is negative 4
Totals in the data table but not in the graph / chart 1
Graph to display Range Label and Mean 0
Creating a Chart on form from selected data in query. 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Remove a column but not data table entry 4

Top