| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Anorexic columns on my pareto chart
I am creating an Excel pareto chart showing eight weeks of data. Each column
is a week ending date. My problem is that the columns are razor thin and there is a huge gap between them and I can't widen them by changing any of the paramteters - I tried adjusting the scale and set the gap setting to zero - no dice. Please advise. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Anorexic columns on my pareto chart
Hi,
Excel has helpfully turned your category axis into a time series one. Right click chart and pick chart options... On the Axis tab set the axis type to be Category rather than automatic. Cheers Andy Stu wrote: I am creating an Excel pareto chart showing eight weeks of data. Each column is a week ending date. My problem is that the columns are razor thin and there is a huge gap between them and I can't widen them by changing any of the paramteters - I tried adjusting the scale and set the gap setting to zero - no dice. Please advise. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Anorexic columns on my pareto chart
WORKED - Thanks Andy, I'm eating again!
"Andy Pope" wrote: Hi, Excel has helpfully turned your category axis into a time series one. Right click chart and pick chart options... On the Axis tab set the axis type to be Category rather than automatic. Cheers Andy Stu wrote: I am creating an Excel pareto chart showing eight weeks of data. Each column is a week ending date. My problem is that the columns are razor thin and there is a huge gap between them and I can't widen them by changing any of the paramteters - I tried adjusting the scale and set the gap setting to zero - no dice. Please advise. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| Can you create a chart with columns and lines along the xaxis? | Charts and Charting in Excel | |||
| stop all the columns coming up the same length in a chart | Charts and Charting in Excel | |||
| stacked column chart across multiple columns | Charts and Charting in Excel | |||
| I want to draw a line through the columns of a chart, plot the o. | Charts and Charting in Excel | |||
Linear Mode
