If I do not plot empty cells, how do I change the category axis?

A

Andrew Edmonds

Hello,

I have four columns of data, the first two of which belong to one condition,
the second two belonging to condition two. I want to compare performance
between the two conditions on the same graph by separating the two. I have
added a column between the two conditions to create a gap, and selected the
'plot empty cells as: not plotted' option. I am now wondering if I can change
the category (X) axis to accommodate this? At the moment I cannot get rid of
the 'spare' value on the category axis. Does anyone know of a way around this?
 

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

X-Axis Appearing in Plot Area 2
switching the axes, categories to values and vice versa 0
2nd axis plotting incorrectly - is there a chart size limit? 2
How do I extend the X-axis in Excel2007 3
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Plotting Date and Time on the same chart axis 1
Excel plotting problems with columns and lines 0
Variables on X & Y Axis 2

Top