ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   If I do not plot empty cells, how do I change the category axis? (https://www.excelbanter.com/charts-charting-excel/102745-if-i-do-not-plot-empty-cells-how-do-i-change-category-axis.html)

Andrew Edmonds

If I do not plot empty cells, how do I change the category axis?
 
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?


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com