Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Miscellaneous > Off-Topic > Visual Basic help
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!
20.Sep: FOURTH CHAPTER IN `HISTORY OF...` PUBLISHED
13.Sep: NEWS ON THE FLY
06.Sep: APOLYTON DONATES TO HURRICANE RELIEF
bottom of page
   - CIVILIZATION 3 $9.99 - CIVILIZATION 2 from $6.95 - CIVILIZATION 2 from $4.25 - ALPHA CENTAURI + ALIEN CROSSFIRE (laptop collection) from $19.99 - ALPHA CENTAURI PC $9.99 -->
Author
Thread    < Last Thread     Next Thread > Post New Thread     Post A Reply
Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 01:16
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
Visual Basic help Support Apolyton, buy Galactic Civilizations

How do I have more than two series in an MSChart? And in VB for Applications (for Excel), how do I modify the contents of a Chart (to the extent of adding/redimensioning series, and to change series colors and such)?

The only VB book I have is no help, and the only VB for Apps book I have is a useless reference

BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 02:56
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Avatar Enlargement: We've got the solution

Try look here - it's a nasty place but sometimes I have succeded to find what i looked for :

http://search.microsoft.com/search/...=4&na=33&cm=512
Solver is offline Solver
Apolyton Duke Of Something
Latvia, Riga
Sep 2000
time: 07:37
  Old Post 28-07-2005 03:06 Visit Solver<br><img src=/forums/images/staff-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Support Apolyton, pre-order Civilization IV

Application.Charts will give you Chart objects that are chart sheets.
Worksheet.ChartObjects will give you ChartObject objects that are charts in a worksheet. After that, you can modify it by changing the object's properties, there were Axes, ChartTitle and loads of others I don't immediately remember.
Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 03:08
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Get a bigger avatar today!

The problem is, when I tried to modify ChartTitle, it told me I couldn't (forget the exact error).
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 03:18
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Full PM-box? Change here!

What do the code look like ?
Solver is offline Solver
Apolyton Duke Of Something
Latvia, Riga
Sep 2000
time: 07:37
  Old Post 28-07-2005 03:20 Visit Solver<br><img src=/forums/images/staff-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Remove this text

Gee Kuci, you should know that to get the best feedback on programming problems, you post the code and the error .
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 03:22
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Get a bigger avatar today!



Yeah, it's resembles a little Molly Bloom's picture guessing threads.
Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 04:13
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Get a bigger avatar today!

I can't post the code, it's for something at work and is "sensitive-unclassified" which means I can't take it off-base.
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 04:15
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Support Apolyton

You don't have to post the whole goddamn program - just the offending line and maybe a pair or two around it.
Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 04:26
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations

Plus the computer it's on doesn't have internet access.
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 04:30
Edit/Delete Message Reply w/Quote
#11 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations: Deluxe Edition

quote:
 Originally posted by Kuciwalker
Plus the computer it's on doesn't have internet access.


I guess that the offending line is shorter than what you just wrote

Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 04:31
Edit/Delete Message Reply w/Quote
#12 Report this post to a moderator
Support Apolyton, buy Alpha Centauri

Dude, I'm not even at work now.

It's something like Chart1.ChartTitle = "stuff" and it's spits out an error.
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 04:40
Edit/Delete Message Reply w/Quote
#13 Report this post to a moderator
Support Apolyton, buy Civilization: The Boardgame

Well, that didn't hurt much

The reason you get an error could be this :

http://msdn.microsoft.com/library/d...jChartTitle.asp

You miss the .text part

Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 04:43
Edit/Delete Message Reply w/Quote
#14 Report this post to a moderator
Increase Your PM Length

Ah.
BlackCat is offline BlackCat
Warlord

Jul 2004
time: 05:37
  Old Post 28-07-2005 05:04
Edit/Delete Message Reply w/Quote
#15 Report this post to a moderator
Put an end to popups!

quote:
 Originally posted by Kuciwalker
Plus the computer it's on doesn't have internet access.


Strange - at my company people would have serious trouble doing their jobs if they hadn't IA.

Are they worried you would start downloading too much art ?
Kuciwalker is offline Kuciwalker
Emperor
of Schmooism
Feb 2001
time: 00:37
  Old Post 28-07-2005 05:17
Edit/Delete Message Reply w/Quote
#16 Report this post to a moderator
Full PM-box? Change here!

No. It's just that the computer is ten years old and no one bothered to hook it up to the web. It works fine for what we use it.
Oncle Boris is offline Oncle Boris
Prince
Once in a brown moon
Aug 2001
time: 00:37
  Old Post 28-07-2005 05:32
Edit/Delete Message Reply w/Quote
#17 Report this post to a moderator
Inflate your Upload Space

May sound stupid, but have you tried to change the chart title manually and record your action? it may be only a small syntax mistake.

EDIT: seems like BlackCat got it.
  < Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:37.
Apolyton Time is 00:37.		     top of page
Rate This Thread:
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0366 seconds (89.53% PHP - 10.47% MySQL) with 30 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |

Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net