473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Change labels on a chart in VB

xtianixm
please can anybody help me on this.


the image below is the output of my chart however the lower part of it that encircled with red is my problem!

is anybody on this forum know how to change those number(1-12) into words
because i want it to be january to december plss help!!

http://www.xtianixm.110mb.com/graph.JPG
Jul 31 '07 #1
18 2462
Killer42
8,435 Expert 8TB
I can't see the image (it's blocked by my work network). But a couple of questions, in case it's not obvious from the image...
  • What version of VB are you using?
  • How are you producing the chart? MSChart control?
  • Do you know the correct name of the component you want to change? Is it the "column label", for example? Knowing this might even give you the answer, as there may be a property corresponding to the name.
Jul 31 '07 #2
yah i see the error ^_^ soryy

kindly copy the link then create new tab and paste it to address
that maybe work ^__^


i use VB 6.0 and im using excel for my chart plss help!
Jul 31 '07 #3
Killer42
8,435 Expert 8TB
I just tried at home, and here's what I see...

Forbidden

You don't have permission to access /graph.JPG on this server.
Jul 31 '07 #4
try to open a new window and type the link and then puff it became cococrunch ^_^

then now u will see it ^_^


if the image doesnt appear again then can u give me a website where i can upload that image!



...very very urgent problem T__T
Jul 31 '07 #5
Killer42
8,435 Expert 8TB
Just attach it to a message here.

What you have to do is post the message, then hit the "Edit/Delete" link (which is only available for 5 minutes after posting) at the bottom of it. On the screen that comes up, below the message you should find a section entitled "Additional options". In there, click "manage attachments".
Jul 31 '07 #6
oyee ive attached it tnx!

..
Attached Files
File Type: zip graph.zip (62.0 KB, 164 views)
Jul 31 '07 #7
Killer42
8,435 Expert 8TB
Hm... well, if it's any help, in my old version of Excel (2000) they are referred to as the "Category (X) axis labels". I'd recommend you try some searching on this. Knowing the correct terms to search for can make a big difference.
Jul 31 '07 #8
..T_T ive search for that matters but i still dont have the right solution on it


..will u help me in searching the solution of my problem T__T
Aug 1 '07 #9
Killer42
8,435 Expert 8TB
Spent a few minutes fiddling. It looks to me as though you probably need to create an Excel.Axis object, then play with the properties, then put that into the X axis (not sure how).
Aug 1 '07 #10
hmmm...Chart-->Source Data--->Series--->Category (X) axis labels,


..that will solve the problem but i dont know how to code it in VB T_T
Aug 1 '07 #11
Killer42
8,435 Expert 8TB
hmmm...Chart-->Source Data--->Series--->Category (X) axis labels
Yeah, that was where I found it too.

I think you need to have a play around with the various objects that are available, such as the Axis object. Also, having a better idea now of what to look for, you should be able to track down some sort of tutorial on the web.
Aug 1 '07 #12
ahmm..yah i got the idea but i dont know how code it T__T

grrrrrr...im stuck!


..anybody HELP!
Aug 1 '07 #13
Killer42
8,435 Expert 8TB
ahmm..yah i got the idea but i dont know how code it
I'll play with it if I can find some time.
Aug 1 '07 #14
ahmm ok!


..i wish u have time asap T_T this is realy urgent but take ur time my friend




..tnx!
Aug 1 '07 #15
Killer42
8,435 Expert 8TB
..i wish u have time asap T_T this is realy urgent but take ur time my friend
Sorry. It's about 7pm here now, and I won't have time to look into this until maybe lunchtime tomorrow.

I've probably said this before, but my guess is it would entail something like creating an Axis object, setting it up the way you want it, then appending it to the Axes collection in the Chart object.
Aug 1 '07 #16
Killer42
8,435 Expert 8TB
I was able to take a couple of minutes to do some searching. One or two links look as though they might be useful. Try here or here or here. Personally, I think the last one looks best. Or at least simplest.

If you want to do some more searching, go for it. I just went to Google and entered "excel chart axis label vb". The ones I posted were just a few from the first page.
Aug 1 '07 #17
ahmm..i see i will try if i can get the idea about the link ^__^


..tnx killer!
Aug 2 '07 #18
T_T..link you provide tells u on how to manipulate certain axis title but we are dealing on how to manipulate the RANGE of category (x) axis labels

Chart-->Source data-->category (x) axis label--> then modify its range to get the label value


..thats the idea now but i dont know how to access the chart--> source data--> category axis so i can modify its range value T__T
Aug 2 '07 #19

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: John Doe | last post by:
Hi all, I've created a pie-chart with Crystal Reports (the VStudio version) and can't seem to change the labeltext on this chart. It now displays a text like "Sum of datatable.field" and I would...
2
by: knoak | last post by:
Hi there, In my form, after validation, labels of wrong fields are turned into a red color. What i want now is when you hit 'reset', to make all the labels grey again. I have the next code:...
3
by: Not Me | last post by:
Hi, I have a report, viewable in continuous form. I don't want the size of the report to change (it should fit address labels on the printer), but in order to minimise the space between empty...
22
by: PeteCresswell | last post by:
I've been to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mschrt/html/vbobjtitleobject.asp, but still don't have a clue. For example, I've got a chart object namde...
0
by: ghanley | last post by:
I have searched the web all day for a lead on this. I have found how to control the Graph object mut not the embedded excel unbound object frame. I am trying to chart the data below on one...
3
by: Ken McCrory | last post by:
I have a web form page (.aspx) with 95 label controls that I now need to be text boxes. Is there an easy way to change those to what I want using something like a find and replace or am I stuck...
1
by: ken | last post by:
Hi, How do you change the font for the data labels on your bar graph report/chart? I have 24 series, and when I change the font of the data label for one series that does not change them all......
0
by: maxx429 | last post by:
Hi all, I am posting this question for a co-worker. She knows very little about Access but has been asked to create some reports. One the requirements is that the report contain a Pie Chart...
0
by: TerryGut | last post by:
I need to show actual values from Series on the X axis of the chart instead of default ones. How to do so using Chart Control of the Visual Studio 2008 Professional? Code (just in case) is placed...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.