Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using cells data greater than xx - graph Excel Using cells data greater than xx - graph Excel
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2024, 10:16 AM
p45cal's Avatar
p45cal p45cal is offline Using cells data greater than xx - graph Excel Windows 10 Using cells data greater than xx - graph Excel Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by massimodfd View Post
Attached the table with some more data, could you pls check it ?
See attached Sheet2. Also Sheet1 tweaked using the other method.
Attached Files
File Type: xlsx msofficeforums52909 01a.xlsx (23.5 KB, 5 views)
Reply With Quote
  #2  
Old 10-14-2024, 12:44 PM
massimodfd massimodfd is offline Using cells data greater than xx - graph Excel Windows XP Using cells data greater than xx - graph Excel Office 2010 32bit
Novice
Using cells data greater than xx - graph Excel 		 
Join Date: Jan 2015
Posts: 29
massimodfd is on a distinguished road
Default
Thank you Logit, but for my purposes it is easier the solution Sheet 2 from p45cal.
Could the graph in sheet 2 be done with a line instaed of ponts?

Thank you !
Reply With Quote
  #3  
Old 10-14-2024, 01:11 PM
p45cal's Avatar
p45cal p45cal is offline Using cells data greater than xx - graph Excel Windows 10 Using cells data greater than xx - graph Excel Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by massimodfd View Post
Could the graph in sheet 2 be done with a line instaed of ponts?
As follows:2024-10-14_210858.jpg


or:


2024-10-14_211223.jpg
Reply With Quote
  #4  
Old 10-15-2024, 03:10 AM
massimodfd massimodfd is offline Using cells data greater than xx - graph Excel Windows XP Using cells data greater than xx - graph Excel Office 2010 32bit
Novice
Using cells data greater than xx - graph Excel 		 
Join Date: Jan 2015
Posts: 29
massimodfd is on a distinguished road
Default
Good! Thanks a lot!

.... can we make appear on X-axis only the values in the column, 15,4 - 17,8 - 19 - 21,5 - 22,1 - 33,4 instead of 5-10-15-20....
Thanks!
Reply With Quote
  #5  
Old 10-15-2024, 01:11 PM
p45cal's Avatar
p45cal p45cal is offline Using cells data greater than xx - graph Excel Windows 10 Using cells data greater than xx - graph Excel Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by massimodfd View Post
... can we make appear on X-axis only the values in the column, 15,4 - 17,8 - 19 - 21,5 - 22,1 - 33,4 instead of 5-10-15-20....
Thanks!:D
With difficulty (if at all).
Does the chart at cell M25 of Sheet2 do anything for you?
Attached Files
File Type: xlsx msofficeforums52909 01b.xlsx (32.1 KB, 4 views)
Reply With Quote
  #6  
Old 10-16-2024, 11:28 AM
massimodfd massimodfd is offline Using cells data greater than xx - graph Excel Windows XP Using cells data greater than xx - graph Excel Office 2010 32bit
Novice
Using cells data greater than xx - graph Excel 		 
Join Date: Jan 2015
Posts: 29
massimodfd is on a distinguished road
Default
Thanks a lot! I will use a graph "dispersion x,y" that best fits to my purposes.
In fact I need to have along X axis the increasing values and I realized that only this graph can fulfill the purpose.
I want to thank you for your time, very kind ! I have learned so much!
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a report with a graph showing data from diferent updates/status data MikelZU Project 1 04-30-2021 12:19 AM
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu AlanBird Excel 3 11-25-2017 03:11 PM
Using cells data greater than xx - graph Excel Auto update excel graph range, ignore data when date reads 00-Month-00 SavGDK Excel 2 06-24-2016 08:05 AM
Need help with excel formula greater than.. bm868 Excel 2 01-02-2016 10:29 AM
How to create a column graph from row data in excel jyfuller Excel 0 07-02-2013 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:09 PM.

Contact Us - Privacy Statement - Top

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