Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2018, 05:41 PM
utkub utkub is offline Fill/hatch the inside of an area which is in a chart Windows 10 Fill/hatch the inside of an area which is in a chart Office 2016
Novice
Fill/hatch the inside of an area which is in a chart
 
Join Date: Oct 2018
Posts: 4
utkub is on a distinguished road
Default Fill/hatch the inside of an area which is in a chart

Hello,
I want to fill/hatch the inside of an area which is created by entering the X and Y coordinates.
I made an example what I wanted to do in the picture on the right.
Thanks for your helps.


Utku
Attached Files
File Type: xlsx example.xlsx (31.3 KB, 10 views)
Reply With Quote
  #2  
Old 10-05-2018, 06:05 PM
jeffreybrown jeffreybrown is offline Fill/hatch the inside of an area which is in a chart Windows Vista Fill/hatch the inside of an area which is in a chart Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

How about this...

https://peltiertech.com/fill-under-b...n-excel-chart/
or
https://peltiertech.com/two-color-xy...rt-guest-post/
or
https://peltiertech.com/Excel/Charts/VBAdraw.html
Reply With Quote
  #3  
Old 10-05-2018, 06:30 PM
utkub utkub is offline Fill/hatch the inside of an area which is in a chart Windows 10 Fill/hatch the inside of an area which is in a chart Office 2016
Novice
Fill/hatch the inside of an area which is in a chart
 
Join Date: Oct 2018
Posts: 4
utkub is on a distinguished road
Default

thanks a lot jeffreybrown, I haven't tried yet but the "DrawFilledPolygon" procedure in the 3rd link will work.
Reply With Quote
  #4  
Old 10-05-2018, 06:38 PM
jeffreybrown jeffreybrown is offline Fill/hatch the inside of an area which is in a chart Windows Vista Fill/hatch the inside of an area which is in a chart Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

You're welcome. Happy charting!
Reply With Quote
  #5  
Old 10-05-2018, 06:40 PM
macropod's Avatar
macropod macropod is offline Fill/hatch the inside of an area which is in a chart Windows 7 64bit Fill/hatch the inside of an area which is in a chart Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at:
https://www.mrexcel.com/forum/excel-...rea-chart.html
https://chandoo.org/forum/threads/fi...a-chart.39948/
https://www.excelguru.ca/forums/show...-is-in-a-chart
https://www.excelforum.com/excel-cha...n-a-chart.html

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 10-06-2018, 09:05 AM
utkub utkub is offline Fill/hatch the inside of an area which is in a chart Windows 10 Fill/hatch the inside of an area which is in a chart Office 2016
Novice
Fill/hatch the inside of an area which is in a chart
 
Join Date: Oct 2018
Posts: 4
utkub is on a distinguished road
Default

Sorry for cross-posting.
macropod thanks for your notice about cross-posting.
I will close the posts as solves in other forums.
Thanks again.
Utku
Reply With Quote
  #7  
Old 10-07-2018, 07:53 AM
utkub utkub is offline Fill/hatch the inside of an area which is in a chart Windows 10 Fill/hatch the inside of an area which is in a chart Office 2016
Novice
Fill/hatch the inside of an area which is in a chart
 
Join Date: Oct 2018
Posts: 4
utkub is on a distinguished road
Default

Another solution by Hui

https://chandoo.org/forum/threads/fi...a-chart.39948/
Reply With Quote
Reply

Tags
area, chart, fill



Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Fill Patterns Conditional Formatting aramaglia Excel Programming 1 05-15-2017 06:35 AM
Text inside text boxes create headings inside my table of contents!!! How do I delete the created he carstj Word 3 04-11-2016 12:46 PM
Fill/hatch the inside of an area which is in a chart Scaling chart to fill entire PDF for basic programme MatthewPH Project 1 01-28-2016 08:09 AM
MS Word 2007 - Chart inside a table. Morningside Word 1 10-04-2014 03:21 PM
Fill/hatch the inside of an area which is in a chart How to edit cell data without changing print area. FIXED print area VictoriaT8 Excel 3 02-22-2013 07:54 PM

Other Forums: Access Forums

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


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