| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
thankyou!!!
"Jon Peltier" wrote: 1. You mean separate the columns in a cluster? Double click any series, and on the options tab, change the overlap to a negative number. 2. I'm not sure exactly what you're describing, but I have a couple suggestions. a. Change by rows to by columns, or if the pivot chart doesn't let you do this, switch the positions of the pivot fields from the row area to the column area, and vice versa. b. If the two pivot fields are in the same area, switch their positions so the one further from the data area is moved closer. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ confused wrote: Hi, I have 2 fairly basic questions about chart formatting but Im a novice so please bare with me! 1. have createda column chart through the pivot table option (the first column chart availiable) How can I set the formatting so the columns have a space between them rather than all being stuck together? 2. On the X axis I have "project name" and on the y axis I have "count of actual items" and "count of expected items". At the moment, each project has a different coloured bar and the bars are in 2 groups, one for "count of actual items" the other for "count of expected items". How can I change it so it is grouped by project, so it would show proj 1 and a bar for "actual" next to a bar for "expected", then proj 2 with its bar for "actual and its bar for "expected". I would want all the "actual" bars to be onj colour and all the "expected" bars to be another colour. thanks very much for any help anyone can give me cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| [Help] How to merge two charts? | Charts and Charting in Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Column Charts - stacked and grouped | Charts and Charting in Excel | |||
Threaded Mode
