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 18 2462
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.
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!
I just tried at home, and here's what I see... Forbidden
You don't have permission to access /graph.JPG on this server.
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
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".
oyee ive attached it tnx!
..
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.
..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
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).
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
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.
ahmm..yah i got the idea but i dont know how code it T__T
grrrrrr...im stuck!
..anybody HELP!
ahmm..yah i got the idea but i dont know how code it
I'll play with it if I can find some time.
ahmm ok!
..i wish u have time asap T_T this is realy urgent but take ur time my friend
..tnx!
..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.
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.
ahmm..i see i will try if i can get the idea about the link ^__^
..tnx killer!
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
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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:...
|
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...
|
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...
|
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...
|
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...
|
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......
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
| |