Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Darryl
 
Posts: n/a
Default 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


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort by row instead of by column? PercivalMound Excel Worksheet Functions 7 August 28th 06 10:41 PM
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
combination clustered column and stacked bar chart John Charts and Charting in Excel 2 April 19th 05 03:49 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM
Clustered column chart with stacked coumns Dave Charts and Charting in Excel 1 January 4th 05 10:40 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"