Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2022, 09:42 AM
DAWNY2007 DAWNY2007 is offline Chart formatting Windows Vista Chart formatting Office 2010
Novice
Chart formatting
 
Join Date: Jan 2022
Posts: 1
DAWNY2007 is on a distinguished road
Default Chart formatting


Hi all. I am very rusty on charts and I have created the attached. My issue with this is that I do not know how to format, so that the columns are closer together. This chart will grow each week and there will be a column (bar) for each week. How do I format to get the columns closer together. Notice the big gap between the 2 dates in the file attached
Attached Files
File Type: xls FTC Chart.xls (40.0 KB, 8 views)
Reply With Quote
  #2  
Old 01-13-2022, 12:34 PM
kilroyscarnival kilroyscarnival is offline Chart formatting Windows 10 Chart formatting Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by DAWNY2007 View Post
Hi all. I am very rusty on charts and I have created the attached. My issue with this is that I do not know how to format, so that the columns are closer together. This chart will grow each week and there will be a column (bar) for each week. How do I format to get the columns closer together. Notice the big gap between the 2 dates in the file attached
Dawny,

The easiest fix would be to edit the horizontal axis and change it from a date axis to a text axis. It's spacing it by 7-day gaps. I not only did that, but then copied out your data as if it would be the data for the next several weeks.

To edit the horizontal access, mouse over it (around where the 1/1/2022 date label is) and then right mouse click and select Format Axis.

There are some good videos on YouTube by various instructors. Maybe you can pick up some tips that way. It's been a while for me, and now with Excel 365 I have many new tricks to learn myself.

Best,

Ann
Attached Images
File Type: jpg CHART_.jpg (103.5 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Fill Patterns Conditional Formatting aramaglia Excel Programming 1 05-15-2017 06:35 AM
Conditional Formatting of Pie Chart Jiing Chiang Excel Programming 0 01-31-2017 04:38 PM
Chart formatting VBA andytheanimal Excel Programming 0 11-26-2014 04:31 AM
Chart formatting Formatting an Org. Chart (SmartArt) to fit in a page DSS90 PowerPoint 1 10-08-2014 07:12 PM
Chart formatting Formatting an Org. Chart (SmartArt) to fit in a page DSS90 Drawing and Graphics 3 10-08-2014 08:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:59 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