Retrieve Values From Excel Graph
Hi,
In Excel i want to retrieve the values from a graph with Visual Basic.
Anyone knows how to do this?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Getting Values From An Excel Graph/chart
I am trying to obtain values from an excel graph. I've got a graph of cost (y-axis) versus time (x-axis) and I'd like to get the values from the graph of a cost at a set time (end of tax year for example). I don't think this is possible straight in excel but was wondering if it's possible through vb? The obvious but longest way would be through interpolation of the values from the table but was hoping I might be able to read values straight from the graph. Any ideas?
Plotting A Graph With Values From Excel Or Note Pad
Hey guys i need so help here..
I need to open either a excel spread sheet or note pad and plot out a x/y axis graph with values obtain from either one of them.. how to i go about doing that??
any help would be most appreciated
thanks
How Can I Retrieve Cell Values From Multiple Excel Documents In A Folder
I downloaded many xls files. I want to write a macro that reads the xls files and display them in a new empty excel file. I don't want to open each file, just get the cell values within a loop. I couldn't find an example on the internet. If you know a tutorial for visual basic appliacations for excel please let me know.
Thanks.
Display Graph Values Of A Graph
Hello all...
I'm graphing data and it creates this really long graph (width wise). How can i make it so that if i hover over a point and it will show me a popup or show the value a textbox with my mouse. I put the X/Y axis with values but u have to keep scrolling back to the beginning of the graph to see around what value it is.
How can i implement it to show the values. Or is there another easier way to do this?
Thanks
Laura
Mouse-over Graph Destroys Excel Graph - ? Virus
I have a bizarre problem with a graph in an Excel (Excel 97 SR-1) spreadsheet . When I pass the mouse cursor over the border of the graph, the plot area spontaneously starts to shrink and then the legend starts moving around the graph from corner to corner. It seems to me that the mouse-over has activated some code, but nothing that I have written. It has the smell of a virus infection. This happens only with this one graph and it is the only graph on the sheet that I have written a simple VB macro to rescale the axes of the graph. The macro takes values entered into cells in the spreadsheet and changes the scales. I suspect the macro has been infected by some virus and somehow it is activated by the mouse-over action. The mouse-over activation is what I see on web sites and software when you pass a mouse over an object and an information box appears or some other effect occurs. What type of software is behind this? Is this a VB function? Some code is being activated and is executing whenever the mouse passes over the border of the chart. Can anyone suggest what I could do to rectify this. I plan to take this spreadsheet to work and scan it for viruses. I may also manually re-type the macro and delete the one there now. Any other comments or suggestion would be greatly appreciated. Thank you.
RDR
Graph Values HELP!!!!!!!!!!
Hi Guys
Attached is a sample graph project that evaluates data during “a” month and between “months”.
What I would also like to view is the individual VALUE on each bar. In the database, I have created a chart in access. When the form is loaded the value is displayed at the bottom of the bar.
Could someone assist in showing me how to formulate the code in vb to achieve the same as in Access.
I have tried numerous ways without success
Thanks in advance
Pieter
Graph With Values From More Than 1 Recordset
Hello
I'm making a graph which shows scores for a User that has taken
tests of different difficulties. The scores are held in separate
tables in my database (tblEasy and tblMedium). Is it possible to
display the 'Easy' scores in the first few columns of the chart,
then the 'Medium' scores in the next few? Please let me know if
you need more information. My code so far is below although I
havent got very far and its a bit of a mess so you may want to
ignore it! Thanks in advance.
Amy
Code:
Private Sub cmdAll_Click()
Dim conConnection As New ADODB.Connection
Dim rstRecordSet As New ADODB.Recordset
Dim rstRecordSet2 As New ADODB.Recordset
Dim cmdCommand As New ADODB.Command
Dim cmdCommand2 As New ADODB.Command
Dim sqlstring As String
Dim sqlstring2 As String
conConnection.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "" & "calculations.mdb;Mode=Read|Write"
conConnection.CursorLocation = adUseClient
conConnection.Open
With cmdCommand
.ActiveConnection = conConnection
.CommandText = "SELECT * FROM tblEasy;"
.CommandType = adCmdText
End With
With rstRecordSet
.CursorType = adOpenStatic
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Open cmdCommand
End With
With cmdCommand2
.ActiveConnection = conConnection
.CommandText = "SELECT * FROM tblMedium;"
.CommandType = adCmdText
End With
With rstRecordSet2
.CursorType = adOpenStatic
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Open cmdCommand2
End With
Dim rs As Integer
Dim rs2 As Integer
rs = rstRecordSet.RecordCount
rs2 = rstRecordSet2.RecordCount
If rs > rs2 Then
MSChart1.RowCount = rs
End If
If rs2 > rs
MSChart1.RowCount = rs2
End If
sqlstring = "SELECT Username, Score from tblEasy WHERE Username =
'" & frmPupilLogin.txtUser.Text & "'"
rstRecordSet.Close
rstRecordSet.Open sqlstring, conConnection, adOpenStatic,
adLockOptimistic
sqlstring2 = "SELECT Username, Score from tblMedium WHERE Username
= '" & frmPupilLogin.txtUser.Text & "'"
rstRecordSet2.Close
rstRecordSet2.Open sqlstring2, conConnection, adOpenStatic,
adLockOptimistic
Dim i As Integer
MSChart1.RowCount = rs
For i = 1 To rs
MSChart1.Row = i
MSChart1.Data = rstRecordSet!Score
MSChart1.RowLabel = ""
rstRecordSet.MoveNext
Next
For i = 1 To rs2
MSChart1.Row = i
MSChart1.Data = rstRecordSet2!Score
MSChart1.RowLabel = ""
rstRecordSet2.MoveNext
Next
conConnection.Close
Set conConnection = Nothing
Set rstRecordSet = Nothing
End Sub
Graph A Range Of Values
Hi there
Does anyone know how to 1) graph a range of values (as in 1 = good, 5 = very good etc) and then 2) to automate this graph once new surveys have been completed.
Please see the attached gif.
Regards
Smoothing Or Filtering Graph Values..
Hi!
I have an array full of values and when I copy them into my graph they create a 'jumping' line like in the top of the image below.
The line should be 'smoothed'..
I did try using this formula and the results are shown in the image too..there seems to be somekind of bug
Example:
Code:
Dim Array(250) as Single, FilteredArray(250) as Single
Dim I as Integer, k as Double
FilteredArray(0) = Array(0)
k = 0.119619887
For I = 0 to Ubound(Array())
FilteredArray(I) = (Array(I) - FilteredArray(I - 1)) * k + FilteredArray(I-1)
next I
Design And Plot Values On A Graph
Hi Guys,
I have never exposed to the designing and plotting values on a graph kind of programming in VB,I am begging you guys who have any idea on solving this problem:
From my project,it happened that the user will have to monitor the process of how many input values his system can generate per sec/min/hours.When user press Start button,A graph must be drawn from 0 to 10 Scales according the Scale selected by the User(there is 0-1 scale,0-100 scale and 0-1000 scale,which the size of these is the same,just that if is 0-10 the graph must be marked 0,1.2.3.......10,if is 0-100 it is marked 0,10,20,30.......100 and if is 0-1000 it is marked 0,100,200,300......1000).It must then retrieve input value from the database and then plot it on a graph on the time selected(sec/min/hours).And if stop button is pressed,the process must stop.
How can I do all these things if they possible,Please Help.
Thanx in advance.
Tmana Ka Mavungu
Graph Values Don't Match Axis
Hi,
(Background)
I've been teaching myself how to use ChartSpace objects and have made a lot of progress. Currently I'm writing a chart that will have two series the data for which are based on a recordset which is really just an SQL query.
(Problem)
My problem is that the output (a line) on the chart is "shrunk". That is, the shape of the line is correct, but it doesn't "stretch far enough". Thus, the value that say, should appear under category "2.5" is marked at category "1.6" or whatever.
However, the very first category-values are correct (category "1" corresponds to value 3 or whatever, the point is, its accurate)
This occurs for BOTH series.
(Code)
The following code shows how I format all my values/categories
Code:
'rs is a recordset passed to the function i'm using to make the graph
ystring = rs.Fields(3).Name
xstring = rs.Fields(2).Name
cq.Open "TRANSFORM Avg([" & ystring & "]) As AvgOfYString SELECT [" & xstring & "] FROM (" & rs.Source & ") GROUP BY [" & xstring & "] PIVOT Project", myDB, adOpenStatic, adLockOptimistic
' Start at the first record and move through the entire recordset.
' Field 0 is the category name, Field 1 is the sales value.
' Create a tab-delimited string for the names and one for the values.
cq.MoveFirst
Do While cq.EOF = False
values = values & cq.Fields(1).Value & Chr(9)
values1 = values1 & cq.Fields(2).Value & Chr(9)
categories = categories & cq.Fields(0).Value & Chr(9)
cq.MoveNext
Loop
Now, this code shows how I format the chart itself
Code:
' Create a chart with one series (called "Sales").
CMetResults.ChartSpace1.Clear
CMetResults.ChartSpace1.Charts.Add
' Create our series. There will be at most two (one project and the other)
CMetResults.ChartSpace1.Charts(0).SeriesCollection.Add
CMetResults.ChartSpace1.Charts(0).SeriesCollection.Add
CMetResults.ChartSpace1.Charts(0).SeriesCollection(0).Caption = cq.Fields(1).Name
CMetResults.ChartSpace1.Charts(0).SeriesCollection(1).Caption = cq.Fields(2).Name
'Set the series categories and values using the strings created from the recordset.
CMetResults.ChartSpace1.Charts(0).SeriesCollection(0).SetData c.chDimCategories, c.chDataLiteral, categories
CMetResults.ChartSpace1.Charts(0).SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values
CMetResults.ChartSpace1.Charts(0).SeriesCollection(1).SetData c.chDimCategories, c.chDataLiteral, categories
CMetResults.ChartSpace1.Charts(0).SeriesCollection(1).SetData c.chDimValues, c.chDataLiteral, values1
' Set the chart type and format the axis as U.S. dollars.
CMetResults.ChartSpace1.Charts(0).Type = chChartTypeLine
(Possible Diagnosis)
What I think is happening is that the fact that there are two series, each with their own values-categories relationships, means they are behaving as if ONLY their categories existed on the graph. Thus Series1 doesn't care that there are categories "1.3" and "1.5" between "1" and "2" because Series1 has no values at 1.3 and 1.5. So instead, Series1 just goes ahead and graphs its value for "2" at category "1.3". THUS the graphs appear "shrunk."
(Parting)
It's hard to describe pictures with words, I did my best. Any help on how to fix this would be appreciated.
Need Help In XML And Vb To Retrieve Values
Hi all,
I have XML file as shown below:
Code:
<log>
<Fruits>
<date>18-Apr-2005</date>
<time>16:14:22<time>
<Stock>
<item>Banana</item>
<item>Apple</item>
<item>Grapes</item>
<item>Mango</item>
<item>Others</item>
</Stock>
</Fruits>
</log>
I need output like:
Banana
Apple
Grapes
Mango
Others
i.e., I want to retrieve the value in between <item>, </item>.
I searched the forum but haven't find anything like my request.
Please help me on this.
Thanks in advance.
Kanna.
How To Retrieve Values
i use common dialog box to open and select the particular file in a path. if i select a particular filename and click open in the dialogbox, then the values inside that file should be retrieved in the listbox.how it is possible using vb coding? similarly, if i open a folder the filenames in that folder have to be displayed in the listbox. please give me coding for the above two.
Labelling X Values On A Graph Drawn In A Picture Box
i have a picture box in which i have draw a graph,
however i want this graph to be rescaled depending on the user's choice.
However i then went the labels on the graph to vary accordingly.
At the moment on the x axis, the values are as follows by default:
0.2 0.4 0.6 0.8 1.0 1.2
however if the user selects the range to be say 0.4 to 1.1 then i would like the labels to appear as follows:
0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1
I never want more than 8 labels to appear, (so for example if the above rane was 0.4 - 1.3, then the labels would change to:
0.4 0.6 0.8 1.0 1.2), but i want them to be only 1 decimal place long, and to appear in the correct place.
I am really unsure how to do this. Should i set up an array of labels, or simply print the text in the picture box???
Any help would be greatly appreciated
James !!!
How To Display The Values Of Points Plotted In A Graph?
Hi all,
I dont know how to display the values that are plotted in the garph. The values should be displayed near the points itself. Please help me resolve my problem.
Thanx in advance.
Bye,
S.Arun
One who fails in his attempts is not a looser, But one who fails to make attempts is a looser.
Retrieve Listbox Values
Hey, I am currently using this code to store values from different text boxes into a listbox on another form which works fine.
If cust.Text <> "" And days.Text <> "" And Location.Text <> "" And Date1.Text <> "" Then
cust1 = cust.Text & " " & days.Text & " " & Location.Text & " " & Date1.Text
Form4.customer.AddItem cust1, 0
End If
The problem I am having is that I don't know how to retrieve all the values of the listbox and store them as a variable
Retrieve All Registry Values Under A Subkey
I'm fairly familiar in using the registry... i have a program that dumps multiple values under a subkey... Is there any way to determine ALL the value names under this subkey without knowing the actually value name... Basically a way to return the number of values and their names....
Retrieve Values From A Hierarchical FlexGrid
Hello all;
For the first time, I am exploring the Hierarchical flexgrid control. Much to my surprise, I have not yet found a way to retrive values from a row when the user clicks on a given cell. Also, is there a way to prevent the user from selecting multiple rows? Thanks,
DA
How To Retrieve Values From Active X Control
I have created a very simple Active X Control for use in ASP pages using VB 6 just to do some playing around. It consists of nothing more than a ListView control. Now, if I were to actually use this in a production environment how would I be able to grab the values out of the Control for insertion into a Database?? Thanks.
Retrieve Values From A VSFlexGrid On Browser
Hi all,
How do i filter out values from a VSFlex grid control which is on the browser onto an asp page?
For eg: I have made an Active X control and have included it into an HTML Page(assume x.html) by using the <OBJECT> Tag.. The user is able to add values into this VSFlex Grid and on submitting this page (x.html) to a page (y.asp) how can i read the contents of the grid since i am unable to pass the grid using neither the GET nor the POST method ????
I am not using any data control to populate the Grid but the grid is dependent on values entered by the user on the browser
Any takers ???
Thanks u've been of great help
Regards
Ashvin
Please Help.. How Can You Save Values Of All Checkboxes To Registry, && Retrieve Them?
Heres the code im using to save values of all checkboxes into the registry..
VB Code:
Dim x As ObjectFor Each x In Form1 If TypeOf x Is CheckBox Then SaveSetting "ProjTest", "Settings", x.Name, x.Value End IfNext x
and heres the code to retrieve the values
VB Code:
For Each x In Form1 If TypeOf x Is CheckBox Then x.Value = GetSetting("ProjTest", "Settings", x.Name, 0) End IfNext x
however, if the checkbox is an array, then the code will not work, because the naems of Check(1), Check(2) and Check(3) are all "Check"..
anyone have a method of saving and retreiving the values that will work with arrays too?
I guess what you can do is save the index as well (ie save x.Name & "," & x.Index") and then when retreiving values use split to apply the settings... but im not sure how to do that part
anyone know?
MSChart: How To Retrieve Data Values From Mouse Over/click On Xy Plot?
I hope someone out there can help me. I've been reading Microsoft's miserable excuse for online help all night and am getting very frustrated.
There seems to be no way to extract plotted values from the chart. I am not using the MS datagrid for this, just filling the chart from an ordinary 2-D array.
I want to display x and y values in a label as I move the mouse over different parts of the scatter plot (or if that won't work, at least have the x-y data displayed when the user selects a data point). Anyone know if this is possible? It seems it certainly should be.
I would be greatly appreciative for any insights from anyone. Also, are there any good resources to learn about MSchart in gory detail? I've looked at dozens of books and searched the web and never found a good, complete source.
Thank you.
Cannot Retrieve Values From A Multiple Line, Pipe Delimited Text File
Hi there,
I am trying to read a pipe delimited file, and then output to a blank document the 'nth' value (e.g. 1st & 4th, as I only want those values) for multiple rows in a file, namely "onlbgl1.sec", stored @ "c: emp".
The file has a header row (row #1), and then subsequent corresponding rows of data.
For each row of data I want to retrieve the 1st & 4th field/values, but I'm currently retrieving 'nothing' - see MsgBox results:
Code:
Dim npath As String
Dim inpstring As String
Dim spipe_loc As Integer
Dim epipe_loc As Integer
Dim onlbgl1(1 To 35) As String
Dim i As Integer
spipe_loc = 1
npath = "c: emp"
'get variables
Open npath & "onlbgl1.sec" For Input As #1
Line Input #1, inpstring
'need second line of data
Line Input #1, inpstring
For i = 1 To 32
If epipe_loc = 0 Then epipe_loc = Len(inpstring) + 1
If spipe_loc > epipe_loc Then spipe_loc = epipe_loc
onlbgl1(i) = Mid(inpstring, spipe_loc, epipe_loc - spipe_loc)
spipe_loc = epipe_loc + 1
'Debug.Print onlbgl1(i); i
Next i
' MsgBox (inpstring)
Close #1
MsgBox (onlbgl1(1))
MsgBox (onlbgl1(4))
Selection.TypeText onlbgl1(1)
Selection.TypeText onlbgl1(4)
Any help would be greatfully appreciated.
Thanks,
Andy
Values {read Values From Excel Sheet Using VBScript}
Hi to all,
i'm trying to do an vbscript file that reads an excel column
(as long as it has a value) and then sum the all cells' values.
If I have
3
1
5
4
it should give:
there are 4 rows
the sum is 13
this is what I have done till now but i don't know how to go on.
Can anybody please help me?
thank you
Code:
Set ob= CreateObject("Excel.Application")
file = "c:file.xls"
ob.WorkBooks.Open file
Set sheet= ob.ActiveWorkbook.Worksheets(1)
ReDim cell(200)
indicator= 1
Do While sheet.Cells(indicator, 1).Value <> ""
cell(indicator) = sheet.Cells(indicator, 1).Value
pappa = cell(indicator)
msgbox pappa
indicator= indicator+ 1
loop
rows= ?
total= ?
ob.ActiveWorkbook.Close
ob.Application.Quit
Comparing Cell Values In Excel To One Of Several Known Values.
Hi Guys
I am trying to create a macro that will go through each cell in a column in Excell to check if that value matches one of 66 known accpeted string values i have. If the value matches, move onto the next line and if the value of the cell does not match one of the 66 known string values I am comparing it to, then I want the whole row to be deleted.
The problem I am having is I dont know what the best way to handle these 66 string values I am using to compare each cell. As its way to big to use them in an IF statement. Can anyone help me out with this please as it would be greatly appreciated as I am new to Excel macros.
Thanks
Edit by Moderator:
Please post Excel questions, in the Excel forum.
Thank you.
Excel Graph And VB6
Is this possible at all? I have a workbook with 3 sheets. The user selects a sheet through the VB6 GUI. (That's the bit I can do so far). I want the user the type a column number in a text box and then this will display all the data in that column in an excel graph on the GUI. I can insert an Excel graph if I create it first on the SS and stick it up in the top RH corner but I would like Excel and VB6 to communicate with each other and do it automatically. When they then type another column in the text box it then displays that data as a graph. I assume I can do that with .hide and .show etc.
Is Excel the right app or should it be access? It's a QC app and I would like to display the graphs after clicking a refresh button.
Any ideas,
Cheers,
TAG.
Graph In Excel 97
When graphing data in Excel 97, for each data series Excel assigns a little shape and color to the data points and lines. There are not very many shapes (triangle, circle, diamond, square) available, and so they get repeated if you have many data series. Is there any way to increase this amount to have more stuff available to you?
Graph In Excel
Hey, just wondering if ye could help me with my code please. I'm using VB6.0 and microsoft excel 2000
I want to import a document into excel and the below code will work for me
T = "c:BrainMaker_autoDebugprediction.dat"
Shell "C:program filesmicrosoft officeofficeExcel.exe " & T, 3
Then I want to graph it - I used the macrorecorder and got the code and then I just combined the two codes together and am getting error "complie error - expected end sub"??? Added in extra END Sub but still same error. What am I doing wrong???
Private Sub Command1_Click()
T = "c:BrainMaker_autoDebugprediction.dat"
Shell "C:program filesmicrosoft officeofficeExcel.exe " & T, 3
Sub Macro1()
Range("A1:A336").Select
Charts.Add
ActiveChart.ChartType = xlLine
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:A336"), PlotBy _
:=xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
Application.CommandBars("Stop Recording").Visible = False
ActiveWindow.Visible = False
Windows("Book1").Activate
Sheets("Sheet1").Select
ActiveSheet.ChartObjects("Chart 1").Activate
Application.Run "Book1!Macro1"
Application.Goto Reference:="Macro1"
End Sub
Would be grateful for any help
Mossy
Graph In Excel
I have used the below code to open a dat document in excel, I need to be able to graph it automatically would anybody be able to help me??? Would really appreciate it
T = "c:BrainMaker_autoDebugprediction.dat"
Shell "C:program filesmicrosoft officeofficeExcel.exe " & T, 3
mossy
Help With Excel Graph
Sorry this is not really a VB question, but did not know where else to put it.
I have some calculated fields in Excel on which I am drawing a graph. Some of the fields are invalid under certain conditions, but I dont want the spreadsheet to show 'N/A' in the cell. If I check the value and set the cell to " " when it is 'N/A', then the graph shows a 0 for that cell. I want the graph not to show anything there like it does when the cell shows 'N/A'.
What are my options?
Vb To Excel Graph
Hi there,
i do hope that this is in the right place. anyway heres my question/scenario
i have a csv file that i use to populate fields in VB. but i need a graph. and for some unknown reason i get a license error when i try and create the graph object on a form. so i thought that going to vb would just be easier.
but my problem is that i dont know how or where to start!
is there anybody that can help me 2 take the info on the labels to a graph in excel?
thanks!
Excel Spreadsheet Graph
I have several spreadsheets that I need to graph but they are not exactly the same. Some have an extra row of data than others, so lets say that "widgets one" may be on row three in one spreadsheet - but on row two on the second spreadsheet. All the info I have on graphing this information gathers the data by a specific row (.Range("A1:B15")....so this will not work for me. Is there some way to query the row for "widgets one" on each spreadsheet, then query for "widgets two" on each spreadsheet....etc. like in an access table?
Put Cell Value Into Excel Graph
Hi All,
I have a graph in worksheet (Chart 1 month), and I have stats in worksheet (Stat).
What I need to do is show a value from sheet (stat) Cell B15 (in text box or something) on the Graph in worksheet (Chart 1 month).
Thanks
Gary
Plot Excel Graph From VB
hi all..
plz help ....
my problem is i need to plot a line graph using the data that i retrieved from the database(access 2000) using VB. eg..the data is 1,2,3,4,5,6,7 (data A from db-axis X) and 33,34,35,36,37,38,44 (data B from db - axis Y) . my data in db is always changin bcoz the data is always updated by the new ones. that's y my axis X is always changing everytime i generate a graph. thaxz for ur help.....
Using Excel Graph Functions From VB
The program I am writing involves drawing graphs from a VB application. Is it possible to create the graph directly by exporting the data to Excel? I would like to be able to control the format.
Thanks, Dan.
Excel Worksheet/Graph
Hi All,
I need to be able to access and place values in a worksheet that is placed on a form. From this I need create a graph on the data. BUT HOW!!
I don't want to open Excel from VB6, just access the worksheet.
I've tried everything and it's driving me MAD. Surely it can't be that difficult, or is it.
Please help.
Dave R.
Excel Graph Object
Hi,
I have gone into the Projects/Components Menu and under the Insertable Objects tab and selected the Microsoft Excel Chart, and the Microsoft Graph 97 Chart, but niether of them seem to be able to do anything, they just sit there. I have to be completely missing something because I don't see the point to either of these objects
DNA
Printing Graph Using Excel From Vb5.0
Hi all,
I would like to know how to print a graph from vb5.0. I am using excel as an
object to print the records.
Thanking you in advance.
Regards
Bharat
Add A Graph To A Form In Excel
I would like to add a graph to a form in excel. I am at a loss on how to even start this. Does anyone know if it is possible? Any help at all would be most appreciated.
Thanks
Steven
Excel Bar Graph Y Axis
Good day fine people.
I have a Bar graph which is listed (Y Axis) from 1 to 168, but I would like to change it to 21 to 189.
Does anyone know how this can be done?
Thank you, DAVE
Copy Graph Into New Workbook "values Only"
Hello,
I have a excel workbook with several sheets. The first one is my "report"-sheet where I have a graph which data comes from the second sheet.
So as this excel workbook shall be a report to hand over to my colleagues I copied the first sheet (report) into a new workbook and handed over this workbook.
Now what happend, if the colleagues open several of these "report workbooks" at the same time, all graphs look the same (they update according to the last opend workbook I think - or was it the first? anyhow- either way). I know that this has to do with the link of the graph to the data source, which in all cases is the same (my workbook). Strange enough, that even the colleagues do not have my workbook on their computer, all of the created workbooks are in a way communicating.
Does anybody know,what's this phenomenon and how to just give the "values" of the graph to my colleagues,without the links to the original workbook like you do with cells (Selection.PasteSpecial Paste:=xlValues).
Very greatful for any advice.
Mary
|
TRACKER
