Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2024, 03:33 AM
MartinGM MartinGM is offline New chart Windows 11 New chart Office 2021
Advanced Beginner
New chart
 
Join Date: May 2023
Location: England
Posts: 65
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
  #2  
Old 02-10-2024, 04:51 AM
p45cal's Avatar
p45cal p45cal is offline New chart Windows 10 New chart Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Select the series in the chart, then:
2024-02-10_114708.jpg
Reply With Quote
  #3  
Old 02-10-2024, 07:43 AM
MartinGM MartinGM is offline New chart Windows 11 New chart Office 2021
Advanced Beginner
New chart
 
Join Date: May 2023
Location: England
Posts: 65
MartinGM is on a distinguished road
Default

Thank you - very clear indeed - but I am falling down earlier in the process . . .

I seem unable to create a proper new column chart in the first place: the object that Excel creates when I select Column for the Chart Type consists of narrow vertical lines which do not respond to changes in Overlap or Gap. The X-axis with dates is correctly presented, as are the numbers on the Y-axis.

Curiously, I copied a Column chart in the same Workbook, that I had created earlier and which correctly formatted and I can edit the Gaps etc, and when I paste it, it takes the odd "vertical lines" format and I can do nothing to change that - just as when I create a new Column chart.i

I have been exploring the options for a new chart and cannot find one whch gives me simple columns as per your example. I must be missing something but I can't see it !
Attached Images
File Type: jpg 2024 02 10 Charting issue.jpg (55.4 KB, 7 views)
Reply With Quote
  #4  
Old 02-10-2024, 07:45 AM
p45cal's Avatar
p45cal p45cal is offline New chart Windows 10 New chart Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Mock up a version of your file so I can have a look, with your current chart attempt, and attach it here.
Reply With Quote
  #5  
Old 02-10-2024, 10:15 AM
MartinGM MartinGM is offline New chart Windows 11 New chart Office 2021
Advanced Beginner
New chart
 
Join Date: May 2023
Location: England
Posts: 65
MartinGM is on a distinguished road
Default

Thank you - here it is . . .
Attached Files
File Type: xlsx 2024 02 10 Attempted column chart.xlsx (14.4 KB, 2 views)
Reply With Quote
  #6  
Old 02-10-2024, 11:42 AM
p45cal's Avatar
p45cal p45cal is offline New chart Windows 10 New chart Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Those narrow columns are because all the dates from nearly a span of 3 months are shown on the x-axis. This is something that MS introduced some years ago; it's a cross between a plain category x-axis and a full blown x-y (scatter) chart.
In this case Excel has opted for the automatic recognition of dates for plotting in a time proportional way along the x-axis.
Easy to change, select the horizontal axis first then:


2024-02-10_183708.jpg


and it should end up like:


2024-02-10_184018.jpg
Reply With Quote
  #7  
Old 02-11-2024, 07:28 AM
MartinGM MartinGM is offline New chart Windows 11 New chart Office 2021
Advanced Beginner
New chart
 
Join Date: May 2023
Location: England
Posts: 65
MartinGM is on a distinguished road
Default

Thank you !
That has been the clearest, most helpful, assistance I think I've ever had . . . and the issue is not only fixed but I understand what happened.
Brilliant.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can we update Chart in PPT based on a table in the excel and the table is part of the Chart Data nareshj PowerPoint 0 07-12-2018 02:29 PM
PPT 2010 - Animated Chart by Series - Animations reset when editing chart agaudet21 PowerPoint 0 10-12-2017 06:18 AM
Bar chart fridos Project 3 05-07-2015 07:17 AM
New chart MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table billcary Project 3 09-22-2014 07:10 AM
Converting manual chart to bar chart? aligahk06 Excel 0 07-03-2010 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft