Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pixel count in Excel sheet charts

Status
Not open for further replies.
phudgens

phudgens

Technical User
Jul 8, 2004
117
US
Is there a way using VBA to automatically determine y-direction pixel count at the top and bottom lines of the plotarea in an Excel sheet chart, regardless of window or chart size? I know that these numbers can be gotten manually by using the GetChartElement method and then using the mouse to pick points on the chart. I'm hoping that there is a way to get this information programmatically without using the mouse.

Thanks,

Paul H.
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
466
sal21
sal21
Andrzejek
  • Locked
  • Question
Hyperlinks in Word cut at #
Replies
2
Views
229
Andrzejek
Andrzejek
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
660
huiettcm
huiettcm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
596
combo
combo

Part and Inventory Search

Sponsor

Back
Top