Computing.Net > Forums > Office Software > excel chart

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel chart

Reply to Message Icon

Name: Excelidiot
Date: November 3, 2005 at 03:09:08 Pacific
OS: Windows XP
CPU/Ram: 256
Comment:

I want to make an excel chart, column type, with three labels on the "category (x)axis" and two stacked columns instead of one, as the program allows me. Practically, I would need to make a combination of clustered columns and stacked columns chart subtypes. Is there ANY way of doing that?



Sponsored Link
Ads by Google

Response Number 1
Name: Grok Lobster
Date: November 3, 2005 at 09:30:11 Pacific
Reply:

Yes, but not very elegant. Enter data as follows:

X-axis categories across the top row with double entry for each category and a space between categories, series names in the left column.

A A B B C C
S1 10 5 30
S2 10 20 30
S3 40 50 30
S4 40 25 10
S5 15 10 25
S6 15 50 25
S7 35 10 25
S8 35 30 25

Format the data series and change the gap width to something small. You should get 2 columns of data for A then a blank column followed by 2 columns of data for B, a blank column and finally 2 columns of data for C.


0

Response Number 2
Name: Grok Lobster
Date: November 3, 2005 at 09:35:46 Pacific
Reply:

Well that doesn't look so good, let me try again

A A B B C C
Ser1_10_____5______30
Ser2_10_____20_____30
Ser3_40_____50_____30
Ser4_40_____25_____10
Ser5____15_____10_____25
Ser6____15_____50_____25
Ser7____35_____10_____25
Ser8____35_____30_____25


0

Response Number 3
Name: Grok Lobster
Date: November 3, 2005 at 09:37:09 Pacific
Reply:

One more try

_____A__A___B__B___C__C
Ser1_10_____5______30
Ser2_10_____20_____30
Ser3_40_____50_____30
Ser4_40_____25_____10
Ser5____15_____10_____25
Ser6____15_____50_____25
Ser7____35_____10_____25
Ser8____35_____30_____25


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: excel chart

Updating Excel Charts in Word Document www.computing.net/answers/office/updating-excel-charts-in-word-document/9048.html

excel chart animation www.computing.net/answers/office/excel-chart-animation/1693.html

Excel Chart www.computing.net/answers/office/excel-chart/789.html