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
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?
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
Summary: went through a few tests and this is what we came to: this problem is consistent across the board in any word document that is linked to any of our s/s. when a chart is pasted as a linked, excel char...
Summary: Hello. I am a student and for a info-class project I have to make in Excel a chart to be animated. I have to do this without actually typing code in VBA, but I am allowed to use macros (to record a ma...
Summary: I created an XY Scatter chart in Excel but I want it to give me the coordinates of each point in the chart. As far as I can tell you can only do either the X axis point or the Y axis point not both. ...