ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   100% Stacked Column - question (https://www.excelbanter.com/charts-charting-excel/30989-100%25-stacked-column-question.html)

Darryl

100% Stacked Column - question
 
Greetings,
I have a chart that is 100% stacked column type. I have 5 columns on
this chart. I need to space 2 of the columns away from the other three.
How do I do this ? ie, if each X represents one of the columns, then I
currently have:

XXXXX

I want:
XXX XX

Any ideas ?

thanks,
Darryl



Jon Peltier

Darryl -

Leave a gap in the data, so in effect, you are plotting the first three
points and the fifth and sixth points, with nothing plotted for the fourth.

Data
A 1
B 2
C 3

D 4
E 5


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Darryl wrote:

Greetings,
I have a chart that is 100% stacked column type. I have 5 columns on
this chart. I need to space 2 of the columns away from the other three.
How do I do this ? ie, if each X represents one of the columns, then I
currently have:

XXXXX

I want:
XXX XX

Any ideas ?

thanks,
Darryl




All times are GMT +1. The time now is 11:12 AM.

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