ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-16-2005, 01:05 PM
Darryl
Guest
 
Posts: n/a
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


Reply With Quote
  #2  
Old 06-16-2005, 09:05 PM
Jon Peltier
Guest
 
Posts: n/a
Re: 100% Stacked Column - question

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 With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 09:21 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0