If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Widening Cluster Chart Columns
Hello,
I have a Cluster Column chart with 3 series. This is data gathered weekly and I have 8 weeks of data, one data point for each series per week. The problem I am having is that the columns in the chart are very thin and do not give a good visual representation of the data. I cannot figure out how to widen the columns. Any ideas? Thanks |
#2
|
|||
|
|||
Widening Cluster Chart Columns
You can double click one series, and on the Options tab reduce the gap
width. If this doesn't seem to help, because all columns for a given week are compressed into the space for a single day, you need to change the axis from time scale to category. On the Chart menu, choose Chart Options, and click on the Axes tab. Under Category axis, choose Category. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ toilinthedark wrote: Hello, I have a Cluster Column chart with 3 series. This is data gathered weekly and I have 8 weeks of data, one data point for each series per week. The problem I am having is that the columns in the chart are very thin and do not give a good visual representation of the data. I cannot figure out how to widen the columns. Any ideas? Thanks |
#3
|
|||
|
|||
Widening Cluster Chart Columns
Thanks, Jon!
Changing to Category worked great. The gap width helped a little, but I had to increase it after changing to Category. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Excel-rolling data linked to chart & worksheet columns must stay | JJ | Charts and Charting | 0 | September 14th, 2005 10:15 PM |
Want to combine columns and horizontal lines in complex chart - Can it be Done?! | James Hobart | Charts and Charting | 3 | February 18th, 2005 02:23 AM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |