#1
|
|||
|
|||
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 ? |
#2
|
||||
|
||||
Duplicate thread https://www.msofficeforums.com/excel...new-chart.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New chart | MartinGM | Excel | 6 | 02-11-2024 07:28 AM |
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 |
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 |