Thread: [Solved] New chart
View Single Post
 
Old 02-10-2024, 04:37 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 101
MartinGM is on a distinguished road
Default New chart

I used to find it easy to add a new chart, select its type, select data etc etc but Excel 365 has defeated me

What I want is a boring old column chart, with the columns touching each other, just like the column picture when I select chart type.

I insert the chart, select the type (column), select the data and the horizontal axis values (they're dates) and the chart appears.

However the columns are near zero width and I can't find how to make them wider.

Somehow I managed to create a bizarre version where each column is a different colour. They're wider, but the whole thing is a mess.

I went into chart type and found that Excel didn't create the Column chart I had selected but something it calls Combo.

If I change the chart type to Column, I get about thee big columns (there are about 50 data points) and the horizontal axis labels change from dates to a meaningless jumble of pairs of numbers.

How do I create a simple column chart, please ?

PS I can work aroud this by taking an old chart, created in an earlier version of Excel, and copying/pasting it and updating the data source etc, but surely there's a sensible way to create something simple ?
Reply With Quote