Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel |