Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Adding Labels To A Pie Chart In A Picture Box, How?


I found this code at http://selfonline-education.tripod.c...r/vbasic18.htm and is exactly what I was looking for:



VB Code:
Private Sub Command1_Click() Dim pieData(10) As IntegerPicture1.Cls     For i = 0 To 9        pieData(i) = 20 + Rnd() * 100        Total = Total + pieData(i)    Next        Picture1.DrawWidth = 3        For i = 0 To 9        arc1 = arc2        arc2 = arc1 + 6.28 * pieData(i) / Total            If Check1.Value Then            Picture1.FillStyle = 2 + (i Mod 5)        Else            Picture1.FillStyle = 0        End If            If Check2.Value Then            Picture1.FillColor = QBColor(8 + (i Mod 6))        Else            Picture1.FillColor = QBColor(9)        End If            Picture1.Circle (Picture1.ScaleWidth / 2, Picture1.ScaleHeight / 2), Picture1.ScaleHeight / 2.5, , -arc1, -arc2        Next i End Sub Private Sub Command2_Click()    EndEnd Sub Private Sub Command3_Click()    Picture1.ClsEnd Sub


My question is how can I add labels next to each slice and a legend next to the pie chart?

Thanks!




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Chart Labels
I work with VB from Excel.
I managed to building charts from my sheets, however, I cannot get any label in the X axis as a whole serie.
The online help, does not give any example as for what I need.

This is what I use for creating a simple

Charts(N).SeriesCollection.Add Source:=Worksheets("X").Range(Worksheets("X").Cells(lFilaInicial, 4), Worksheets("X").Cells(lFilaFinal, 4))

and works fine, however, I would like to give another serie (as a range same as above ex.), for adding the labels corresponding to that serie.

Appreciate any help. Thanks.

Pie Chart And Labels
Hi,

I have a pie chart in my program which is all the colours of the rainbow. Problem is I am printing it out in black and white. What I want to do to overcome that problem is to have the labels for each wedge of the chart next to the wedge. I would also like to have the percentage amount showing as well.

I found a topic which helped me get the values to appear. The code is :

    For i = 1 To .Plot.SeriesCollection.Count
         With .Plot.SeriesCollection(i).DataPoints(-1).DataPointLabel
            .LocationType = VtChLabelLocationTypeOutside
            .Component = VtChLabelComponentSeriesName
         End With
      Next i

the value ".component = ...." determines what value appears next to the wedge. If I have ".component = VtChLabelComponentPercent" then I get the percentage value appearing. If I use ".component = VtChLabelComponentSeriesName" then the label for the wedge is the same as in the legend.

If I try to combine the two together ".Component = VtChLabelComponentSeriesName & VtChLabelComponentPercent"
then it doesn't work. If I try
 ".Component = VtChLabelComponentSeriesName + VtChLabelComponentPercent"

then I get the two values but there is two little squares between the values. This looks a bit odd.

Does anyone know how to write the code so that both values appear but I don't get the two little squares...

Thanks

Simon

Data Labels On Pie Chart
I am creating an add-in that will generate pie charts automatically.

Each cell among the range used to build the chart has a title in the cell immediately above it. I would like to label the pie chart with these labels. I would prefer to use the Legend. But I'm not sure how to do this. Thanks in advance.

MS Chart && Axis Labels
MS Chart displays Axis values in scientific notation if the values go above a certain size. i.e. "1.2e+006"

Is there anyway to prevent this from happening?

MS Chart Axis And Labels
Hi everyone,

I am actually working on a program using MS Chart quite intensively which is a bit of a pain sometimes, especially to find some information about it...

I am plotting several curves from a datagrid control, i programmed a dynamic zoom and some other features. my current problems are the following :

1) sometimes the horizontal axis labes switch from horizontal to vertical, depending on the number of points on the plot. I would like to force it to stay horizontal, but I can't find the property that could fix it.

2) I would like to be able to use 2 different vertical axis with 2 different scales properties. I know how to create a second vertical axis but i can't create its own scaling property, i mean it uses the same one of the first axis. I think that it must be pretty easy but I can't find it, so if anyone could help me on this that would be great !!!

cheers from Australia,

Vincent !

Data Labels Using MS Chart Control
Hi masters
I am using ms chart control to create a bar graph in vb 6.0. I am not able to show data label of bars. Can someone tell me the property to set?

Thanks a lot in advance.

Ms Chart - Position Of Labels On X Axis
Hi

I have a program which is creating a graph to show temperature for each hour of the day. Is there a way to make MS Graph plot the hour labels on the X Axis below the grid lines as is usual for a scatter/line graph, rather than having them plotted inbetween two grid lines (which seems to be geared towards column graphs)?

Thanks for any help.

Mark

Changing Pivot Chart Axis Labels With VBA
Hi all!

I've got a pivot chart in Excel that shows CPU time on the y-axis and time of day on the x-axis. Unfortunately the data series usually (but not always) starts at 4:40 AM so when the pivot chart is created the first x-axis label is 4:40. The labels are shown with a 2 hour interval so the next ones are 6:40, 8:40, ... , 20:40, 22:40. The data always ends at midnight.

How can I, using a VBA maco, have the chart change automatically when created (the raw data is processed and the chart created with macros) so that the first x-axis label is the first full hour after data starts? E.g. if it starts at 4:40 then the first label is 5:00.


I'm scoobied.

Give Value To X-axis Chart Labels In Lotus 123
Hi everybody,

How could I give value to x-axis labels in Chart which I created in Lotus 123 spreadsheet?

If I do Record Script in Lotus itself, I'll get
ChartObject.XAxis.TickLabels.Datalink.Source = [A:A3..A:A15]

so, how can I code this script in visual basic program?
I tried ChartObject.XAxis.TickLabels.Text = labelRange
'labelRange is range [A:A3..A:A15]
but it doesn't work.

TQ

Excel - Chart Object - Category X Axis Labels
I have a chart object generate in VBA as follows:

With ChartObject
        'Set up Chart Title
        .HasTitle = True
        .ChartTitle.Text = ChartTitle
        
        'Set up Source Data
        .SetSourceData Source:=SourceData, _
            PlotBy:=xlColumns
        
        'Set up Y1 Axis Title
        With .Axes(xlValue)
            .HasTitle = True
            .AxisTitle.Text = YAxisTitle
            .MinimumScale = Module1.SetScaleValues(LCL, "Deflate", 20) 'Set Minimum Scale to 20% less than LCL
            .MaximumScale = Module1.SetScaleValues(UCL, "Inflate", 20) 'Set Maximum Scale to 20% more than UCL
        End With

End With

I am passiing in the variables which contain my sources etc.

What I am unable to get working is to set each value on the x axis to look up the value in my first column in the data range (my index). So when you hover the mouse cursor over a data point - it tells you which index (X value) the point relates to.

If you manually set this in a chart - through the qizard - it automatically sets the x axis category labels as the first column. My code sets all columns as the series. I dont want the first columns as the series at all.

Any help would be much appreciated.

Thanks....

Adding Labels When I Need Them
Hello all i have a quick question...

This is what im trying to do...

I open my database and check for a field called "Note". If the field has a "YES" in it then that name needs to be displayed in its on label on the form, if not then it goes to the next record until EOF.

Now since i do not know how many labels will be needed, how can i add a label without putting 100's of labels on my form waiting to be "visible" once it goes though the database?

...example:

Code:
say there are 8 people that has "YES" out of 30. Therefore i will need only 8 labels on the form in order like:

[name][name][name][name][name][name]
[name][name]

Or if it had 11 people that has "YES" out of 30 it would look like this:
[name][name][name][name][name][name]
[name][name][name][name][name]
I can acheive this with a listbox but i would like to have the users see there name WITHOUT having to scroll down to find it (if its even on the list in the first place)

Any help would be great, thanks!
David

Adding Labels
hi what i want to do is add the numbers in 2 labels together eg

label1 = 2
label2 = 5
label3 = 7

label1+2 are added together to give the value in label3 but this inst what hapens when i try this i get "25" in label3 how can a make it do it as a sum

Adding Labels Runtime.
I would like to create a label for each new user as they login to a program . I would like to have the list of labels displayed on a form. When a user logs off that users label is also removed.

I have tried control arrays, and dynamic arrays but nothing seems to work well.

Help Please!!!

Adding Values In Labels
Pry the dumbest Question today, but I'm having problems adding values in labels. I have Six Labels that will end up with a value. I then have a score Label. I was trying to get the Score Label to add up the values in the other six labels. But I get this. If their is a 2 in the first label and a 3 in the next I get 23
me.uitotalScore.Text = Val(Me.uiCount1.text) + Val(me.uicount2.text)...and so on.
What the heck am i doing wrong?!?!?!

Adding Multiple Labels
Hey I forgot how to add multiple labels together....isn't it :

lblTotal.Caption= Val(lblTCds.caption)+Val(lblTRecords.Caption) + lblbTTapes.Caption) + Val(lblVideo.Caption)


??? Or do you put one open and closed paranthesis for the whole process? Get back at me...thank u!

Adding Two Labels PROBLEM
This is a very simple question but I am also new to this.  I am having trouble adding two labels together.  As an example:

label1.caption = 3
label2.caption = 5


label3.caption = label1.caption + label2.caption


I keep getting label3.caption = 05

I am wanting to get a total, not the two labels put together.  I know this is a very simple procedure, but I am having no luck with it.

If anyone can help me this would be very much appreciated.

Thanks,
Gary

Adding Labels To A Line In Excel
I have a map drawn out in excel. When a line between two point meets certain criteria, the line changes colors. I would also like to display some information about the line. Is there a way to add a label to a line? Can I add a comment box to a line? Is there a way to get the coordinates of the endpoints of a line and add a text at h/2, w/2?

Adding A Value Of A Vaiable To A Labels Caption?
something like:


Code:
dim varname as string
varname = "jon"

label1.caption = "my name is, varname"

'so the output is:
'my name is, jon"
'trying to do this without having to use two labels

MSChart Adding Labels To Columns
I'm having trouble adding data points and specific labels to my mschart?? First time mschart user.

vb project attached.

Thanks

Adding Labels At Runtime (array)
I've searched for this but nothing I found seemed to be quite what I was looking for.
I want to add an array of Labels at runtime,
UBound being List1.ListCount - 1

Any Help is appreciated!

JO

Text Labels On Picture
I use the 'picture.Pset (x,y)' command to put dots various places on a picture. Now I need a command to put text labels next to the dots. How do I do that?

How Do I Print A Picture With Labels On Top Of It???
Hey all,

I've managed to get VB to print my picture however at runtime this picture also has various labels on top of it. (the picture is a blank 'flight pass' and the various labels grab info from other forms to complete the flight pass)

however when i print using:


Code:
printer1.paintpicture image1.picture, x, y

printer.enddoc

the printer does not print the captions ontop of the pic. how do i add them into the code so they will also print (in their current positions on the form) ????

Help Adding Link Labels To A Scrollable Container
Hello,

I've written an application which has many records. I've provided a search bar in which the user can enter a keyword and the search will return the records with matching keywords. However, I'm looking to return the records as links to the records. The thing I need is to create the link labels on the fly and add them to some kind of container (like a list box) which is scrollable if the number of links exceeds the size of the container. I've looked at list box and list view and they don't seem to have the ability to house link labels. If I've missed something stupid or if someone knows a way to do this please let me know. Thanks for your help in advance.

Kenny

Printing (Painting) A Picture Box W/ Labels
Ok all you VB pros... a success story for this one isn't in the forums and I could really use and would really appreciate your input on my prob...

I have a picturebox with some labels and another picturebox inside of it. I need to be able to print that picturebox and have it show the labels and picturebox that are inside of the main one.

thanx for the help,
squirrelly1

Dragging Labels And Picture Boxes
How do i drag labels and/or picture boxes across a form?

Picture Boxes, Labels, And Transparency
Ok, I'll explain the whole problem because there may be several ways to
solve this and hopefully someone knows one. What I'm doing is creating
a specialty template editor, similar to say a corel draw (but for
specific uses). What I need to be able to do is import graphics and
text and then move them around the background until they are where I
want them and then export it out as an image file.

The problem is that I need to be able to move text over an image and
vice versa. Labels always go behind a picture box when you move them
regardless of Zorder so I tried putting each label in its own equally
sized picture box. That solve that problem, now the text can go over
the other images where necessary. But this causes a new problem.
Picture boxes don't have transparent backgrounds so if I move text over
an image, you can't see behind the text to the image, you see a big
white (or whatever background color is) block. I tried putting an all
transparent gif in the picture box then putting the label over top that
but it didn't seem to work.

I've seen these issues in the newsgroups before but none of the answers
really matched what i'm trying to do.

Thanks in advance!

Chris

Printing ImgImage.Picture With Labels
I have a program that displays a health inspection certificate in an image control. Two labels (lblLabel.BackStyle = transparent) display on top of the picture, and are used for the "fill-in" parts of the certificate (i.e. "This restaurant, 'McDonald's', passes all health codes", with 'McDonald's' appearing in one of the labels).
The point of all of this is to be able to print a certificate with the individual client's information on it. So far, my code will only print the image (the drawing of the certificate), and won't include the text in the labels on the printed document. Do the labels have to be "grouped" to the image control? Should I use a PictureBox instead?
I've zipped some basic code, with the labels set to permanent values (typically the labels are either populated by entering new data or opening a database, but this is just to keep it straightforward). Save the included crappy drawing of a certificate to your C: drive. Thanks.

Adding Grid Of Labels At Runtime - For Summary Display
hi guys

Code:
Public Sub SummaryDraw()

    Dim lbldisplay As New Label
    Dim labelsize As Integer, toplabeltop As Integer, labelleft As Integer, row As Integer, column As Integer


    For row = 0 To 15
    For column = 0 To 15
    form1.lbldisplay = New Label()
    form1.lbldisplay.Name = row & "," & column
    form1.lbldisplay.Size = New Size(labelsize, labelsize)
    form1.lbldisplay.Top = toplabeltop + (row * labelsize)
    form1.lbldisplay.Left = labelleft + (column * labelsize)
    form1.lbldisplay.BackColor = Color.Black
    form1.frmDisplay.Controls.Add (lbldisplay)
  Next
Next

End Sub


This code sort of works in VB but i cant get it to work in VBA i dont know aht thing that differs from VBA to VB to make it work so any help would be great.

What im doing is to create a grid made with lables to display my data, I also want to add a tag to each label as its created as my range is on a loop and links to a label using a tag.

In theory i think it will work but i'm not sure if im constrained by vba.

AL




Edited by - Geof on 11/5/2007 6:15:38 AM

Labels Graphic Picture Transparent Image
Hi,
    I hope someone can help me here, and I have explain myself clearly.

The project I'm build is Label stickers, what the software does is allow user to print labels stickers with selected text, and pictures. Selecting background color of the labels and color for the text. The picture color background will be the same as the backgournd label color, and the picture color will be the same as the text. Thus having the software print out the labels with the text and picture with selected colors.

I have tried using .GIF transparent to print the labels, on the screen it displays the corrrect color, but when printing, you will notice the difference between the label background color and the picture color background (the picture BG is alot lighter than the Label BG).

Is there any way or any dll or ocx library that allows me to change the picture color and picture background.
example picture

Any suggestion would be great.

Adding Data (VB Lines And Labels) To A Internet Explorer Window?
Hello,

I am wondering - Is there anyway to have a Internet Explorer window open and then through a VB program draw Lines and Labels.caption on that window?

I couldn't find anything on that but someone more advanced may know???

Thank you in advance for any replys!
Stilekid007

Adding New Series To The Chart
I try to make a code adding new series. But there is problem in addressing.
What would you think for the code below:

Sheets("Grafik1").Select
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).Values = "=Sayfa1!" & Range(Cells(300, 7), Cells(600, 7)).Address(True, True)

Adding Trendline To Chart With VBA
I have a problem with adding a trendline to a chart in excel. I have made an application in Access that has a function that should make a chart in excel. The data for the chart is taken from a table in access. Everything works except adding a trendline. I have tried with many things in order to get it to work but no luck.

Can somebody help me?

Here is the code...

Dim xlsApp As Excel.Application
Dim newWorkBook As Excel.Workbook
Dim newWorkSheet As Excel.Worksheet
Dim myChtObj As ChartObject
Dim trend As Trendlines

Set myChtObj = newWorkSheet.ChartObjects.Add _
(Left:=10, Width:=350, Top:=m + 510, Height:=200)

With myChtObj
.Chart.chartType = xlXYScatter
.Chart.SetSourceData Source:=newWorkSheet.Range(tex)
.Chart.DisplayBlanksAs = xlNotPlotted

With trend
' plot a trendline

End with
End With

MSChart - Adding Numbers To Chart
Hi,

I'm fairly new to using MSChart. I have developed a chart which works ok but I want to know if it's possible to add the numbers to the chart.

eg. If I have a pie chart, and it's representing 3 different pieces of data (50, 20,5) but when the chart appears these numbers are not shown on the chart. And its not possible to tell the exact numbers been represented.

Is there a function to add these numbers to the chart?

Thanks in Advance

XYScatter Chart - Adding Series
Initially, I have a XYScatter chart in Ms Excel.

Then, I would like to add a new series, where I can determine the X values and the Y values manually.

Below is the code that I generate the 1st Series


Code:
xlsChart.Application.ActiveChart.SetSourceData Source:=xlsWBook(1).Sheets("Analysis").Range("A:B") ', PlotBy:=xlColumns
xlsChart.Application.ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Analysis_Chart"
My 2nd series will be column C(for X values) and column D(for Y values).

I tried this:


Code:
xlsChart.Application.ActiveChart.SeriesCollection.Add Source:=ActiveWorkbook.Worksheets("Analysis").Range("C:D")
There will be another 2 series added. 1 is from column A to C and another one is from column A to D.

But I only want 1 series. Any idea whats the code like?

Adding A 'series' To Chart In Excel Through Vb
hi, i created a chart in excel and import it to visual basic, the problem is i want to create another 'series' on the same graph through vb, can anyone knows who to add a 'series'?

here is the code i used to create the chart in excel:

Dim ch As ChartObject
Dim chart1 As Chart
Dim currentchart As Object

Set xlApp = New excel.Application
xlApp.Workbooks.Open xlsfilename

xlApp.Worksheets(SheetName).Activate
Set ch = xlApp.ActiveSheet.ChartObjects.Add(100, 30, 350, 270)
Set chart1 = ch.Chart
chart1.ChartType = xlXYScatterLines
chart1.SetSourceData Source:=xlApp.ActiveSheet.Range("V1:V" & Subgroup_No), PlotBy:= xlColumns

chart1.Axes(xlCategory).HasTitle = True
chart1.Axes(xlCategory).AxisTitle.Text = "Subgroub Number"
chart1.Axes(xlCategory).AxisTitle.Font.FontStyle = "Bold"

chart1.Axes(xlValue).HasTitle = True
chart1.Axes(xlValue).AxisTitle.Text = "Range(R)-mg"

Set currentchart = xlApp.ActiveSheet.ChartObjects(1).Chart
currentchart.CopyPicture xlScreen, xlBitmap, xlScreen

frmGraph.Image1.Picture = Clipboard.GetData
frmGraph.Image1.Visible = True

xlApp.DisplayAlerts = False
FileName:=xlsfilename
xlApp.Quit
Set xlApp = Nothing
frmGraph.Show

Adding A Trendline To A Chart In Excel With VBA
I have a problem with adding a trendline to a chart in excel. I have made an application in Access that has a function that should make a chart in excel. The data for the chart is taken from a table in access. Everything works except adding a trendline.
I have visited the msdn-page, but I don't get their solution to work in my program. What is it that I have incorrect?

Can somebody help me?

Here is the code...

Dim xlsApp As Excel.Application
Dim newWorkBook As Excel.Workbook
Dim newWorkSheet As Excel.Worksheet
Dim myChtObj As ChartObject


Set myChtObj = newWorkSheet.ChartObjects.Add _
(Left:=10, Width:=350, Top:=m + 510, Height:=200)

With myChtObj
.Chart.chartType = xlXYScatter
.Chart.SetSourceData Source:=newWorkSheet.Range(tex)
.Chart.DisplayBlanksAs = xlNotPlotted
End With

' plot a trendline

' the suggestion on the msdn-page
' "Subscript out of range (Error 9)" is given by the debugger

Worksheets("activesheet") _
.ChartObjects(1).Chart.seriescollection(1) _
.Trendlines.Add Type:=xlLinear, Name:="Linear Trend"

Adding Horizontal Line Into Existing Chart
Hi, im trying to add an horizontal line to my current excel chart (clustered columns), but without sucess..my code isnt giving any error but i dont see any change in my chart. my Y axis is from 0 to 180 with jumps of 20 and i would like to draw a line at 115.

here's the code snippet that im trying:


Code:
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(3).XValues = "={115,115}"
ActiveChart.SeriesCollection(3).Values = "={-1000,1000}"


TIA

Adding A Chart And Accessing Datasheet From API In Word
I have added a reference to my VBE in Word to the MS Graph 8.0 library. I am trying to create a chart programmatically and do this:
 
    Dim MyChart As chart

    Set MyChart = ActiveDocument.InlineShapes.AddOLEObject("MSGraph.Chart.8")
    
The chart is created in Word but when I try to do anything with MyChart , like access the datasheet object, I get
"Object variable or With variable not set" because it still = Nothing.

What am I doing wrong? Thanks in advance.

Ed

Chart Fill Format Picture
I am trying to add a picture to the background of my chart and I can get it to fill the whole page, i.e. stretch the picture, but what I really want is to just display the picture unscaled once at the top left of the chart.

For some reason the options are disabled through the normal Excel user interface so I thought I'd try and do it programatically, but I just get an error:


Code:
With ThisWorkbook.Charts(str_Chart1).ChartArea
.Fill.UserPicture _
PictureFile:= _
"Picture location and file name (.gif)", _
PictureFormat:=xlStackScale, _
PictureStackUnit:=1, _
PicturePlacement:=xlAllFaces
.Fill.Visible = True
End With

I'm not sure what the Stack Unit and Picture Placement parameters do as the help is slightly vauge.

How To Modify Chart In Crystal Rpt File At Runtime Without Adding The Rpt In The Prj
hi guys,

i need help !!!!

How to modify a chart in crystal rpt file from vb code at runtime without adding the rpt in the project thru the crystal report designer.

please help!!!

thanks


pratik

Can I Save A Excel Chart As A Picture File?
I am developing an Acess application to generate a Word document as our weekly production report. This Word document report's layout has been pretty much fixed. It has some tables containing data and some charts (can be Excel Charts). I can ,in Access, get this word document object and use vba code to manipulate (update) the data in the table of the Word document using the data in my Access database. I also want to generate the charts in the word document using the data in my Access database. Any Good Ideas?

Currently, I link the worksheets in a workbook in my Access database. I link each worksheet as a table in my Access database and transfer the data to each linked table (worksheet). These worksheet's data is linked to a charts in this workbook. Every time, I change the data in each worksheet, the Chart is changed. How to transfer the chart to the Word documnet without mannualy copy and past as picture to the document.
I want automatically change the charts in the document usning vba either in Access or Excel, Word.

I can also place some Image controls in the Word document and use the picture property to link each picture files. This will require that each chart be saved as a picture file. Can I save each chart as a picture file (eg. bmp file) using vba code?

Chad

Can't Copy MS Chart Graph Into The Picture Box To Be Exported As A .bmp...
Ok whenever I try to capture the graph itself into the picture box, I get "invalid picture" errors. Can anyone tell me how to paste the graph in the picture box? Once that is done I can use SavePicture to export the file as a .bmp. Thanks in advance

Chart.CopyPicture : How To Modify Picture Size/resolution ?
Hello All,

I am using the code below in Xcel (2002) VBA to copy a chart picture to the clipboard and paste it to mspaint.

I need a large and high-res picture for publication. How can I modify in VBA the size & resolution of myChart and the copied picture ?

Please note it seems I have to use Format:=xlBitmap , since Format:=xlPicture does not handle well transparency [I have many semi-transparent colored rectangles on top of myChart forming a 'heatmap']

Thanks.

Olivier


Code:
myChart.CopyPicture Appearance:=xlScreen, Format:=xlBitmap, Size:=xlScreen
Dim Paint
Paint = Shell("MSpaint.EXE", 3)
Application.Wait (Now + TimeValue("0:00:05"))
AppActivate Paint
SendKeys "(^v)", True
....

Excel Truncate Error When Copy Picture Chart
One coworker has a chart in Excel. When she uses shift-edit to copy picture as picture, as shown on screen, she gets an error saying the chart is too large & will be truncated. When she then tries to paste it into Powerpoint, the Y axis is distorted (shortened). Copying as a bitmap works, but greatly increases the file size, which is undesirable for emailing.
However, this doesn't happen on anyone else's machine. They can copy picture as picture as shown on screen (exact same chart) just fine.
The only difference I can find is that the others use W98, while the problem machine uses WXP. All use Office 2K. I use W2K & have no problem.
Is there a solution or setting to this problem? Thanks.



Edited by - salvelinus on 10/20/2005 6:34:41 AM

Can Picture File Insert Into VB Chart Control As Background Image
Hi All,
is there any VB control ( especially Chart control ) can insert a picture file ( jpeg, GIF ) as a background when i diplaying a line-chart ? and How ?

TIA

regards
Jason

Adding Labels To A Report At Runtime (using Microsoft Data Report Designer 6.0)
Hi,

I have just tarted using the Microsoft Data Report Designer and I need a little help. I am trying to get it to add labels to a report at run-time rather than design time.

The report is supposed to save the results of some analysis. Lets for simplicitry sake say that I just want to display a list of value stored in an array, but the number of placs in the array is not known until the proram has actually run. I.e. it would e something like this:

for i = 0 to ubound(myArray)-1
myReport.addItem (newLabel(i))
newLabel(i).caption = myarray(i)
next i

Does this make sense, but how would I do this (there is no 'addItem' property of the report)?

Adding A Picture...
Is it possible to place a picture on a java applet? Or text or something?

Adding Two Picture Box
The VB attachment regarding for connects two Picturebox by a line connector. In this project there is two button one for adding Picture box and another one for drawing line as connector.I am facing problem to connect the two picturebox by lineconnector button. While Picture box moving the picturebox loose its connections with previous picture box. I want to join the picturebox by the lineconnector. And the pictureboxs always in connected via the line even the picturebox move by mouse move???Anyone have an idea how to slove this problem?????

Adding One Picture To Another
How can I add (draw ontop) a picture to a picture in a picturebox?
(try saying that 3 times fast! ) it doesnt have to change the picture in the picture box but I want to draw many of them so I cant just put the picture in an image control and put it ontop.

Any ideas? It's probably very simple but I know nothing about picture programming.

Copyright © 2005-08 www.BigResource.com, All rights reserved