Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Rotate Chart/Graph


is it possible to rotate a graph. i need to turn my stacked cone graph upside-down so that the point is facing down and not up


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Swap/Rotate Chart Axis
I am trying to chart a range of dates, for example. I have some boats that are on contract between dates a and b. I would liketo plot several boats with their contract date range. I have tried using a bar chart, but all the lines start at 0. I got it working using an Excel 2007 Stock chart, however, it is in the wrong orientation. I would like to Rotate the Chart 90 degrees, swap the axis, or find a better method all together. I cannot post the spreadsheet as its confidential.

View Replies!   View Related
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:

1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.

2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.

3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).

What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.

View Replies!   View Related
How Do I Not Graph A 0 Value On A Line Chart
I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?

View Replies!   View Related
Chart Or Graph Percentages
I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc....

View Replies!   View Related
Graph-Chart In Cell
I was tracking down simple ways to generate ASCII character based bar charts and came across this stunningIncellBarChartExample where the author suggested this can be done using VBA code.

I am very new to Excel and EXCEL VBA. Can someone help me sketch how the coding for the above example (include mixed colors) might be done? Is there a special font that need to be used?

View Replies!   View Related
Create Box Chart/Graph
How can I create a box chart showing graphically a median, 1st and 3rd quartile and a minimum and a maximum?

View Replies!   View Related
Multiple Series Chart/Graph
I have a scatter graph that has over 100 curves that im need on one graph that at the moment i putting each x and y and name in by hand in series. I have been doing it for hours and have looked round the site to see if anything similar answer on ozgrid would help but im baffled

i was just wondering if there is an easier way of doing this

i havent really used macros but iv been reading up on it can i used it to do this?

I have added the table and graph and this is how i would like all the columns to look like
its the table called graph that makes the curves that i would like to be able to add in quickly
the rest im not too fussed about.

View Replies!   View Related
Drop Down Chart To Run A Graph Macro
I am trying to figure out how to activate a macro from each item in a drop down list. I also need the macro to recognize which item is chosen and to use that items data (say cells C3:C11) to create its graph. I know how to create an individual macro that will create a graph for the item but not a general macro that can be used to graph all items just discerning the difference in where the data is (which item to graph). Is this possible????if so please include code (amatuer programmer).

View Replies!   View Related
Create Stacked Bar Chart/Graph
I need to plot a stacked chart. I have attached a sample of it. I need to plot, category As X and subcategory and and its percentage as Y (stacked chart). In the attached sample I plotted a chart. The problem is, the series name showing is not correct. It takes the series name from the top row.

View Replies!   View Related
Automatically Update Graph/Chart
I have a macro that extracts data from a source workbook. The data is owerwritten every time that I use the macro. Now I have a graph that everytime I use the macro does not update with the new data, Is there a clever way to do that? The code for extracting from the workbook is the following:

Sub Extract()
Dim myFileName As Variant
Dim SourceWkbk As Workbook
Dim CurrentWkbk As Workbook
Dim testWks As Worksheet
ActiveWorkbook.Sheets("CURRENCIES").Select
ActiveWindow.SelectedSheets.Delete
myFileName = Application. GetOpenFilename("Excel files,*.xls")
If myFileName = False Then
Exit Sub 'user hit cancel
End If................

View Replies!   View Related
Rolling X Month Graph Or Chart
I've been working on this for a couple hours and I am close to getting it how I want. Basically I want to have a rolling 15 month graph that will change according to the month you choose in the drop down tab. Example: I choose july 2007, the graph will show data from july 2007 to September 2008. I have the graph functioning, however my formulas are off (collecting the wrong data). I've included a spread sheet

View Replies!   View Related
Combined Bar And Line Graph/Chart
creating a graph / chart using Ms Excel? I've been trying to do it myself but to no luck as I'm just a novice Ms Excel user. I'm trying to create a bar graph and combine with line graph based on these data. kindly refers to my attachment image for an example of desire graph. For line graph, it should display individually based on the given data. These are my daily data and I want to have an analysis graph so that I could monitor my computer's usage and its efficiency.

Computers Data Usage
--------------------------
Computer01 10 50.00%
Computer02 691 68.89%
Computer03 107 81.03%
Computer04 190 81.25%
Computer05 2099 82.89%
Computer06 1247 50.88%
Computer07 2786 10.00%
Computer08 69 22.00%
Computer09 300 18.00%
Computer10 1829 87.07%
Computer11 746 27.43%
Computer12 437 91.33%
Computer13 301 62.50%
Computer14 24 40.00%
Computer15 93 83.33%
Computer16 192 92.45%

View Replies!   View Related
Not Plot Zero Values On Chart/Graph
one of my excel reports, i am using a dsum formula and plotting a chart against it. i do not want to show the zeros on the graph, is there anyway i can do that, i could not find anything in the tools -> options.

View Replies!   View Related
Auto-Extending Graph/Chart Range
I have a Line Graph with 2 lines on it. Is it possible to write a macro to extend the range (Source range) of one of the lines ? I would also like to add a Data Label to the newly added point.

For e.g. If I have Line 1 graph only till 65, I want the macro to extend the range by one row to include 95 and also display a datalabel ......

View Replies!   View Related
Create Chart/Graph From Text Strings
Can I build/present a "Pie" chart DIRECTLY from a list of "ABC" letters WITHOUT counting the occurrence of each one of them and using the results [nor VBA / nor Pivot-Table] - which is the trivial way of building charts !?

An example of such a list will be:
A
A
A
B
B
C
C
C
C
C

View Replies!   View Related
Chart Or Graph Data Based On Hours
I would like to chart (pie or graph) sales based on the hour they occured.

In excel, I have column A - the time stamp, and column B, the sale. Note that each sale has its own unique time stamp.

View Replies!   View Related
Pie Chart To Graph Percentage Of Total Expenses
when you open up the file please ignore everything above the blue bar. That was the old data which was arranged wrong. I have actually figured a lot of this out but i am stuck. The graph is set up so when you click on the drop down menu (F26) it changes the graph to the relevant data. Now the bottom graph is currently graphing the Months Expense1 as a total of all Expense1. So January Expense1 was $100 so its 26% of all Expense1. and when you click on the drop down button you can changed the data to Expense2 and the graph changes. YAY ok thats cool. However, thats not what i want. I want the pie chart to be graphing the expenses as a percentage of total Expenses. So the drop down menu would be of the months instead of the expenses.

I have changed that with relative ease, but I cant get the data to graph how i want it to.

I have been using OFFSET() formula and the define name manager to set up the previous graph. You can easily look at the formulas i have used instead of me trying to explain everything. Please help. This is the test bed for a budgeting spread sheet I am working on.

if you can help me out that would be great.. Please try not to use Macros because i dont understand them all that well and I need to take what is done in this spreadsheet and learn from it and change it so it works when are thre 10 expenses.


View Replies!   View Related
Making Chart/graph From Text By Occurrence
I track inventory/sales for a very small sole proprietorship. I'm looking to track the number of items that I sell based on the text that I enter in a certain column.

Specifically, I want to have a visual chart/graph to show the percentage of each size/color of an item that I sell, as I sell it. When I enter the words "3T pink" I want the chart/graph/whatever to show another quantity of this category. As I sell a new item, I want the chart to reflect it.

The problem I'm having, is that the graphs/charts require two data sets, but I want the graph to calculate it for me! All I want to do is enter the text for specific items, and when the text occurs subsequent times, I want this reflected in the graph/chart.

It seems so much more simple in my head....basically I want a dynamic chart, not based on a static data set.

View Replies!   View Related
Dynamic Chart/Graph For Changing Ranges
I have a database in excel with a lot of tables in which lets a uses a combo box so the user select can view just one table.

I want to be able to create a macro so when a button is pressed, it copies the data into a new workbook and creates a chart so they can do whatever they want without disrupting anything in the original workbook.

I have been able to find code that will export the data and create a chart (see below) but the problem is the range changes from table to table so I need to find a way of changing how the chart picks up the data range.

Sub Chart_New_Book()

Sheets("Temp").Select
Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("A1").Select
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:C10")
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
End Sub

So at the moment when charting ony cells A1:C10 will be plotted no matter what the size of the table is and making the target range bigger only sees the blank cells being plotted.

View Replies!   View Related
Chart A Graph Of Jobs Over A Period Of Time
I have an Access database, with a table of jobs processed.

One column for Job ID (Unique), Date it was processed, By Who it was processed and Comments ascoiated.

I need to chart a graph of Jobs over a period of time. How many jobs done per date. In excel preferebly, I have programs like Database Plus for excel. And I am familiar with VBA. I can't figure out how to uniquely sort how many jobs for each date. As there are numerous job entries for on the same dates. I think it can be done with an SQL query or sorting it with VBA somehow. Any help will be greatly appreciated. Or can anyone suggest an application designed for charting with Access databases in Excel?

View Replies!   View Related
Chart/Graph X Days From Another Workbooks Data
I have a spreadsheet in the office which is completed and saved in a folder daily. Im looking to add a line chart onto the daily spreadsheet which shows the figures from the last 20odd days so that they can be easily compared.

View Replies!   View Related
Graph & Chart: Data Source Changes Monthly
I am trying to write a macro that will automatically change the source data for a graph. This is an existing graph that is on tab GraphYTD and the data for the graph comes from DataYTD. The number of rows of data will change monthly, but I would like to use the same graph template every month. Here is my

Sub SortYTD()
Dim myBottom As Long
myBottom = Sheets("DataYTD"). Range("B65536").End(xlUp).Row
ActiveChart.SetSourceData Source:=Sheets("DataYTD").Range("F2:I" & myBottom)
ActiveChart.Location Where:=xlLocationAsObject, Name:="GraphYTD"

End Sub

I am getting Runtime error 91 - object variable or with block variable not set.

View Replies!   View Related
Determine Breaking-Point In Graph/Chart
finding a function/formula for determining the breaking point (Yvalue) in a graph, that doesn't necessarely equals the maximum value of that curve!

So the curve in the sample is a stress strain curve (tensile test) of a fibre and at the end it breaks and the Y value returns to 0. I would like to determine that Y value before it is 0, so the last Y value before it returns to zero.

I thought of a formula like:
display last y value before it drops with 90%...
but I don't have a clue how to write it in maths...

View Replies!   View Related
Plot Multiple Series In 1 Graph/Chart
how can i plot multiple series of values in one graph after checking some check boxes, which i have previously done, randomly?

View Replies!   View Related
Plot On Chart/Graph As Zigzag Pattern
I have the following list of values which I want to plot as a zigzag. But when i create a line chart from them, the lines connect the zeros and the non-zero points - while I want the lines to connect only the non-zero points - so that there is a zigzag-like pattern shown.

the Data:

0
0
0
0
0
1.4343
0
0
0
0
0
0
0
0
1.4332................

View Replies!   View Related
Test Selection Values & Graph/Chart
The user will select a range (example, B4-Z4). The macro needs to test each cell to see if the number is in a certain range (example, is the number in the cell between 21-40, 41-60, 61-80, etc? - these ranges will not always be the same on each worksheet). If the cell is in that certain range, that cell is a 1 for that range. Example,

B4 = 23
21-40 = 1

C4 = 30
21-40 = 2

D4 = 45
41-60 = 1

After all ranges are tested, it will be graphed on a separate worksheet with the x-axis being the ranges (21-40, 41-60) and the y-axis will be the total number of cells that fit in the range. The above would be....................

View Replies!   View Related
Chart/Graph Changing/Variable Range
I have a vast database where I have linked charts. I send the data from a macro to the database and sometimes there are 1000 inputs and sometimes there are only 20.
How would i set up my charts to only graph the inputs that are present?

View Replies!   View Related
Prevent Graph/Chart From Updating/Refreshing
I am dealing with plotting large amounts of data (millions of cells) across multiple series. Everytime you click, add a new series or do anything it redraws the graph taking a while. This Is there are way to prevent Excel 2003 from plotting a graph until you are done setting it up?

View Replies!   View Related
Chart/Graph For Individual & Group Totals
I am working on the evaluation of a survey. I had 212 respondents which could be divided into three distinct groups. I would like to present the results of a question in columns that reflect the total frequency count in percentages. At the same time I would like those columns to be stacked in order to illustrate the contribution each group has made to that particular answer. I have attached an xls file with the data and a demonstration of the outcome I am trying to achieve.

I haven't been able to create the graph so that the columns display the total count in relation to all respondents on the one hand and at the same time are broken up into the individual groups. Among others, I have read the thread: http://www.ozgrid.com/Excel/stacked-column.htm but that doesn't answer my question as the Total there is actually the cumulative total of the other values.

View Replies!   View Related
Interval Distribution Plot Chart/Graph From Selected Row
I have several worksheets with thousands rows (independent variables) and hundreds columns (all dependent variables). Each line basically gives me hundreds values for each independent variable - see below:
...
C9 39.65 653.95 5.28 163.56 99.56 14.49 ... ...
E9 7535.92 21500.56 2835.88 3122.98 7225.34 5371.25 ... ...
G9 111568 298021 12940 31645 181797 36996 ... ....
...

I need to know how the values in each row are distributed, and I ideally plot a 2D column graph of the distribution. Is there a way to do that and create/program a macro (with relative button on the workboook) that does it automatically once clicked?

Very often there are outlying values (bigger or smaller by a factor of 1000 or even more), mistakes, which I would like to identify and fix possibly.

View Replies!   View Related
Determine Half-Way Point Of Bar Series On Bar Chart/Graph
i have created a xlColumnStacked chart using VBA in excel 2000. i would like to place a line in the center of one of the Points(). How can i locate a specific point, for example Points(1), so what i can then "draw" a line in the center

View Replies!   View Related
Source Location/Address Of Series In Graph/Chart
Looking for code that returns the cell address of a series in a pre-existing graph. I have a graph that already has Source Data manually assigned to it. Is there a way to find just the cell values or location of a single Series in a SeriesCollection object? I know that in order to assign a series of data to a Series object, you do something like this:

ActiveChart.SeriesCollection(1).Values = Worksheets("My Worksheet").Range("A1:F1")

The issue I am tackling with is a graph that already has preexisting data in the Series object, and I just need a quick and easy way to find the address of this data set.

View Replies!   View Related
Macro: Plot Graph/Chart By Series Of Rows
I've been trying to work out a code for a while now to plot some series in rows on a graph. The wonderful Mr Pope helped me with one before but for series in columns but i just don't seem to understand it enough to use it for this problem. the graph already has 2 series plotted (called the envelope) so i have to use seperate series to plot the data.

Basically the name of series is down column A
but the range is from E1 to Y1
and the data to be plotted on the graph which already has two series plotted in it is E2 to Y2, E3 to Y3 etc. iv been trying to use this code but failing miserably

Sub adddatatopsd(Name As Range, XData As Range, YData As Range)
With ActiveSheet.ChartObjects(1).Chart
With .SeriesCollection.NewSeries
.ChartType = xlColumnClustered
.XValues = XData
.Values = YData
.Name = Name
.ChartType = xlXYScatterSmooth
End With
End With
End Sub...........................

View Replies!   View Related
Position Chart/Graph Tick Mark Labels
how to put the categories (Column H) out of the graph? (so more to the left, so not in the grey background) Here in the attachment you will see that the titles are in the graph instead of outside the grey background. Is it possible to do that?

View Replies!   View Related
Set Chart/Graph Minimum/Maximum Scale To Nth Smallest & Largest Value
I am trying to manually format a few graphs in my sheet. I, however, leave the major units of the axes to be automatically calculated. The code that I use is given below:

ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = Range("Min").Value
.MaximumScale = Range("Max").Value
End With

Now what this does is that it sets the maximum of the scale exactly equal to maximum of the range being plotted and hence a few parts of my graph overlap with the border of the plot area. Is there any way in which I can round the max and min scale of y-axis to the next highest and lowest major unit respectively or may be add and subtract a value proportional to the major unit of the y-axis. I cannot add a constant in the code given above since I that does not suite my requirements.

View Replies!   View Related
Add Shape & Rotate
i am trying to draw a shape (square or rectangle) using vba textbox's i have managed to draw 2 of the 4 lines.

i am stuck on the ShapeRange.Flip msoFlipHorizontal codeing.

i have attached a example of what iam trying to do.

the coorinates from the last line enterd are saved to sheet1 for use with the next line entered ...

View Replies!   View Related
Rotate Image On Userform
I am rotating an image on a userform by uploading different gif images to simulate the rotation. There is an annoying screen flicker around the image when changing images that I would like to get rid of if possible. how to get rid of the flicker or a different technique I could use to rotate an image? 1st attempt - uploading different pictures

For h = 1 To Sheets("Bar Contents"). Range("B" & ItemRow) Step 1
PictureLocation = ThisWorkbook.Path & "PicturesTransparent" & Sheets("Bar Contents").Range("C" & ItemRow) _
& " " & h & ".gif"
GameUserForm.DrinkAnimation.Picture = LoadPicture(PictureLocation)
Sleep 50
DoEvents
Next h.........................

View Replies!   View Related
Rotate The Names In The Roster
Need excel formula (not a marco) to rotate the names in the roster.

View Replies!   View Related
How To Rotate The Contents Of Columnes Upside Down
How to rotate the contents of columnes upside down, I want the bottom values to be at the top and vise varsa.

View Replies!   View Related
Rotate Text On A User Form
how to rotate a label to a 45 degree angle on a user form.

View Replies!   View Related
Flip Rotate Data Range
I have data map in excel. I want to create a program to flip the data map. The data from the top of the data map will flip to the bottom of the map and the data from the bottom will flip to the top of the map. The process is like a mirror reflection.

Like example:

after a command button is clicked, the data will changed to be like this:

View Replies!   View Related
Rotate Range, Keep Defined Names Consistent.
as the title says, i need to rotate a range but to keep all defined names (single cell or range) consistent.

i.e.
lets say i have the following cells filled:

1 2 3 4
1 2 3 4
1 2 3 4
1 2 3 4
1 2 3 4
1 2 3 4
1 2 3 4
now i have a few defined ranges. lets say:
range name, refers to
mycell1row1, A1
mycell90roanything, B1
mysomething, C1
mysomthingrange, A1:F1

etc.

what i need in the end is this:

1 1 1 1 1 1 1
2 2 2 2 2 2 2
3 3 3 3 3 3 3
4 4 4 4 4 4 4
and for defined names:
mycell1row1, A1
mycell90roanything, A2
mysomething, A3
mysomthingrange, A1:A7


View Replies!   View Related
Make A Graph That Will Graph Against Time
How can i make a graph that will graph against time? lets say i have a bank balance like this:

1/2/2000 $500
1/3/2000 $600
3/12/2000 $400

there may be more than one entry on any one given day, or there may not be an entry for 2 weeks. How can i graph the running balance in a way that it will show the timeline just as a calendar year(or however long i selected) and the points are plotting according to their date, not just equally spaced out.

View Replies!   View Related
Line Graph: (line Graph To Display An Amount Over Time)
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.

A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg

Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):

Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).

View Replies!   View Related
Non-consecutive Values To Rotate Through In A "for" Loop
I currently rotate through 3 values of XXX (i.e., 0, 1, and 2) like this:

For XXX = 0 To 3

What should I write if I want to rotate only through XXX values of 0, 2, and 3?
Should I write:

For XXX = (0, 2, 3)?

Not sure it'll work...

View Replies!   View Related
Chart Hyperlinks: Attach A Macro So That When The Chart Is Clicked It Returns To Sheet - Home
I know this has been discussed a number of times, but here is my problem
I have three charts in my workbook. I want to attach a macro so that when the chart is clicked it returns to Sheet - Home. I have using the following:
worksheets("Home").activate. But after I protect each chart and the workbook, and save and exit. When I reload the Workbook it has forgotten the assigned macros and nothing happens.

View Replies!   View Related
Odd Chart: Combine Data From Multiple Worksheets And Make A Chart
I am trying to combine data from multiple worksheets and make a chart. I have about 200 keywords in every worksheet (about 50), and some of them repeat themselves through worksheets and some don't. For every keyword, I have an associated value in the next column that I want to portray over time (each worksheet is for a different period).

So what I need to figure out is how to be able to pick any 10 keywords from the worksheets and put them in a line chart where I can see the associated value for each period for every worksheet so I can compare my keywords' efficiency. The tricky part is that some worksheets do not contain the keyword and other worksheets contain the keyword in a different cell than the previous wsheet.

View Replies!   View Related
Combine (Overlay) Bubble Chart & Point Scatter Chart
I would like combine (overlay) a bubble chart with a connected point scatter chart. I understand that, without VBA, this is not possible. However, I understand that, by using VBA, the markers of a scatter chart can be configured as circles with their size proportional to values in a specified column. This pseudo-bubble chart can then easily be combined with a connected point scatter chart.

My question is: does anyone have any VBA code to share that shows how to configure a scatter chart as the type of pseudo-bubble chart described above.

View Replies!   View Related
Line Chart - 12 Month Chart Moving With Dates
Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.

The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.


View Replies!   View Related
Pareto Chart, Set Line Chart Origin At Zero
I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.

Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved