Anorexic columns on my pareto chart

G

Guest

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.
 
A

Andy Pope

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
 
G

Guest

WORKED - Thanks Andy, I'm eating again!

Andy Pope said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do widen columns in a column chart? 3
Widening Columns in Chart 7
Widening Cluster Chart Columns 2
Unevenly spaced x axis on chart 1
Autoscale horizontal axis on chart 4
Help, my columns are negatives! -- bug? 6
how to hide zero values on line chart 2
Time scale makes columns too narrow 2

Top