Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2020, 03:29 PM
oscarlimerick oscarlimerick is offline Request for help with microsoft graph Windows 8 Request for help with microsoft graph Office 2013
Advanced Beginner
Request for help with microsoft graph
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default Request for help with microsoft graph

Hi folks, I am trying to create a clustered column graph to display Date Vs KM driven, as you can see from the attached JPEG file, my dates in column A are spaced 1 week apart (every Sunday), and the corresponding KM driven in column F. This graph will go on for 4 years, but for brevity sake I will illustrate the problem I have selecting only cells A15-A18 and F15-F18. As you can see, creating a clustered column graph based on these cells displays the graph to the right of this data. The problem I have is it is displaying not just the dates I have selected, but all the days in between. Because this graph will go on for 4 years, or 208 weeks, this will make the graph way too large. What I really want to do here, is make a clustered column graph that displays ONLY the weekly dates in column A and not all the days in between. Is there any way to do this? Thanks
Attached Images
File Type: jpg Clustered column graph.jpg (179.8 KB, 14 views)
Reply With Quote
  #2  
Old 09-11-2020, 08:00 PM
Purfleet Purfleet is offline Request for help with microsoft graph Windows 10 Request for help with microsoft graph Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

It is always better to post a work book so that we dont have to waste time recreating the data (probably wrong)


Click on your chart, right click format axis > in the box on the right there are 4 icons


Fill & Line
Effect
Size and Properties
Axis Options <Click on this one> then expand Axis options


Change the Units > Major to 7 days



Attached Images
File Type: jpg dateaxis.JPG (36.4 KB, 11 views)
Attached Files
File Type: xlsx Request for help with microsoft graph_Purfleet.xlsx (14.0 KB, 4 views)

Last edited by Purfleet; 09-11-2020 at 08:03 PM. Reason: typo
Reply With Quote
  #3  
Old 09-12-2020, 07:46 AM
oscarlimerick oscarlimerick is offline Request for help with microsoft graph Windows 8 Request for help with microsoft graph Office 2013
Advanced Beginner
Request for help with microsoft graph
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

Hi there, and thanks for the quick reply. Your suggested solution worked, this is exactly what I wanted to do, and thanks for the feedback, from now on I will post the actual workbook instead of screen snapshots
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Request for help with microsoft graph Hyperlink request dbalaam Word 2 12-23-2017 04:54 AM
Graph - Need a second X axis on the Top of Graph paulzy95 Excel 6 10-09-2016 12:07 PM
strange add-in request for help JohnS PowerPoint 1 10-24-2015 08:26 AM
Request for help with microsoft graph column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM

Other Forums: Access Forums

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