Excel Chart

Nov 22, 2006

Is there a way to have 3 axis in a chart. Right now I have "X" and "Y" but need a 3rd.

View 9 Replies


ADVERTISEMENT

Excel 2003 :: Daily Stock Chart AND Random Scatter Chart Data

Jan 14, 2014

I need to plot various data on top of stock charts.

This data could be irregular in date: it could be weekly, or simply random.

To plot this data by itself requires a Scatter Chart.

From what I know so far, you CANNOT DO THIS.

However, I suspect this could be done if I build a Stock Chart from scratch using a Scatter Chart.

Error bars can be used to make the tails, however, I don't know how they built the body bar which has the characteristics of a bar (border, and interior.)

But since I don't really need those two characteristics, I just need a wider error bar line that is provided in the chart edit window. I'm guess through a macro, there are wider line widths assignable.

View 5 Replies View Related

Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart

Nov 27, 2011

I am looking for a creative way to display a pie chart within a data point marker of a line chart.

My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)

I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.

I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.

The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)

the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.

I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.

View 1 Replies View Related

Excel 2003 :: Filter Data In Graph / Chart (without Having To Create New Chart)

Dec 29, 2011

I have a spreadsheet created in Excel 2003 (which is what we use at work, unfortunately).

My employees periodically take a test to ensure they have certain items memorized (or are making progress to that end). The spreadsheet rows show all 46 of my employees, and their test scores. The columns are the dates that the tests are administered. I can create a line graph based on the chart data, and interpolate these data with no problems.

The problem is that there are 46 employees! 46 lines on the same graph make for a very cluttered, hard to understand visual. I want to simplify the view by "filtering out" some of the data.

I have an additional column in my spreadsheet for each employee's work area (Area 1, Area 2, etc), and another column with data based on first letter of last name (the values here could be "A-G", "H-M", "N-S" and "T-Z", for example). I figure i could filter my line graph based on these two columns. For example, somehow select just Area 1, and reduce the number of lines on the graph to 16. Or better yet, Choose "Area 2" AND "A-M" and end up with 7 employees (and therefore 7 lines on the graph).

Here's what i have tried:

1) Select the work area column, and use the Filter, which created a drop-down list at the column heading. When i use this drop-down list, i can easily filter the data in the worksheet by Work Area, but this is not reflected in the line graph, which still shows all 46 lines. The problem was that i forgot that i had set the Calculation Options to "Manual". Setting this to "Automatic" (or leaving it on Manual and pressing F9) solved the problem, as the chart now updates when i use the filters. Calculation options are under the "Formula" tab in 2007, or in Tools -> Options -> [either calculation or formula, i forget what it's called] in 2003.

2) Create several separate line graphs in several separate sheets. I wouldn't want to assign someone else the task of maintaining a spreadsheet of such inefficient design.

View 1 Replies View Related

Org Chart With Excel

Feb 20, 2009

Hello Excel Guru's. I have more of a question or seeking advise on a task I have at hand. I have one of two files to work with. One file has about 20 columns of data, about 1300 rows. The file is employee data, namely: The employee ID, Employee Name, the employee's supervisor ID and the employee's supervisors name (columns A, B, C and D). What I'm after a heirarchy of sorts. I've used visio to create an Org Chart but once the data has changed (supervisor is terminated or changes departments) you have to re-run the org chart and that can be time consuming.

I was hoping that someone out there might have done something with VBA or a pivot that can display the sheet in complete heirarchy format.

I do have a second file that contains the same employee list, but this one has supervisors listed in a more of a level. Level 1 would be the CEO, supervisors listed in level 2 would be the employees reporting to level 1. Employees listed under Level 3 report upto the supervisor in level 2, and so on. I have 6 levels. Level 6 is all employees that have no direct reports.

Again a pivot table is a nice start but what I have is many of the supervisors are found in both level 5 and level 4....and the CEO is in all levels.

View 6 Replies View Related

How To Have Excel Select A Row From A Chart

Oct 11, 2013

I have a large chart made up with hundreds of rows and around 10 columns. Normally I would use certain pieces of data to find the correct row that would provide my answers. I have set up an extra column beside the chart that will put an X next to the row that will provide my answer. What formula could I use to have excel copy the row beside the X, and put it on another sheet in the workbook?

View 1 Replies View Related

Excel Chart To Show Timeline?

Nov 23, 2011

I have a spreadsheet where users can enter a time using the 24 hour clock - these times are random and can be anything within the 24 hour period.

I want to create a chart or graph that has a timeline of 24 hours, (in multiples of 1 hour starting at 07:00 and going right through to 06:00), and I need the times entered by the users to appear on the chart to give an overview of when these incidents are happening most.

I was thinking that the cluster or scatter chart might work but I can't figure it out. I don't actually need both X and Y Axis, just a timeline - is it possible?

View 3 Replies View Related

Excel Chart Using OFFSET Function

Mar 14, 2012

I have an Excel Workbook with data in Sheet1 and a chart in Sheet2.

I use the OFFSET function to define the data range. In Sheet2, I have 3 cells, B2(column), B4(row) and B6(period). I have slider to adjust the values in B2 and B4.

I define the data range at follow.

Xchart =OFFSET(Sheet1!A1,Sheet2!B4,0,Sheet2!B6,1)
Ychart =OFFSET(Sheet1!A1,Sheet2!B4,Sheet2!B2,Sheet2!B6,1)

When I tired to put in this into value series

=Book1.xlsx!Ychart

The error message ...

Reference not valid. Reference must be to an open Worksheet.

View 3 Replies View Related

Background Color In Excel Chart?

Jul 13, 2012

How I can add background color to an excel chart. I need from left to right the 2/3rds to the chart to be light gray and the other 1/3 light blue.

View 7 Replies View Related

Excel 2010 :: How To Create Bar Chart

Dec 26, 2012

how do i make a bar chart on Excel! 2010

Basically i have these figures

Male : 21
Female : 18

I want to make a bar chart, When i use Excel and try to make it - i get a chart which shows the right column height but the Male and Female bars are BOTH IN 1 Colour. How do i make it so that male bar is blue and female is pink.

View 3 Replies View Related

Excel Macro For Charts In PIE Chart?

Jan 28, 2013

i am creating a macro to animate the charts, but i need a code where, if i select a block in the chart it should take the point name automatically.

View 1 Replies View Related

Excel Chart - Defining X Axis Value

Mar 15, 2013

Excel chart that whenever I am defining than X axis value then excel chart will show 2 unit more than whatever is my maximum value.

View 3 Replies View Related

Creating Word Chart From Excel Via VBA?

May 2, 2013

I have a bunch of data about companies in an Excel workbook. I need to be able to create a "summary document" about a selected company in word. One of the items that needs to be in this summary is a pie chart.

This code works fine for generating the basic text of the document:

Code:
Sub export_to_word()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim companyName As String
Dim address As String
Dim revenue As String

[code]....

Creating the chart has been more problematic. I adapted the following code from an example found on MSDN:

Code:
Dim valueChart As Chart
Dim chartWorkSheet As Excel.Worksheet
Set valueChart = wrdDoc.Shapes.AddChart.Chart
valueChart.ChartType = xl3DPie
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)
chartWorkSheet.ListObjects("Table1").Resize chartWorkSheet.Range("A1:B12")

[code]....

What I've found though is that this code is based on a macro inside the word document, not excel. So it runs fine from within word, but within excel it throws an error at this line

Code:
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)

because ChartData is not in the object model in Excel. how to proceed at this point.

View 1 Replies View Related

Excel Pivot / Regular Chart

Aug 13, 2013

Basically the two instances shown are the same, one is a pivot table, the other is copy pasted values off the pivot.

I need to prepare a chart for this data such that the years are show on X axis and the "frequency intervals" and the Count are shown on Y axis ( Im assuming one would have to be one on primary and one on secondary).

What this data is conveying is that e.g. in year 2002 there were 16 customers who bought between 0-799 quantity of a given item, in 2003, 48 customers bought a quantity between 0-799 and so on and so forth.

See attached the image [URL] .......

View 3 Replies View Related

Creating Excel Line Chart?

Mar 10, 2014

My chart is coming in blank when I set up a line chart. This is my data that I selected and then pressed chart. 1997

63.9%
1998
63.2%

[Code].....

View 9 Replies View Related

Paste First Chart Into Second Chart But Maintain Format Of Second Chart?

Jul 12, 2013

How do I paste the first chart into the second chart but maintain the format of the second chart?

View 2 Replies View Related

Excel 2007 :: VBA To Insert Org Chart Object

Dec 24, 2011

I want to use VBA to insert an Organisation Chart in Excel 2007 (ie if I did this manually it would be Insert, SmartArt, Hierarchy), but I cannot find anything on line that shows how to do this in Excel 2007. I know the code for Excel 2003, but that does not work in 2007.

View 4 Replies View Related

Excel 2010 :: Dynamic Line Chart

Jul 12, 2012

I would like to plot the 1st dynamic line chart as shown in [URL] ..... but i never write any excel macro 2010 before, any sample of this?

View 4 Replies View Related

How To Control Individual Functions In Excel Chart

Apr 13, 2014

All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also given (60) for the X axis.

Why do the NORMAL bars aren't located on the place they should on the X axis?

For example, the 1st bar (from the left), should be a little more to the right. The others should move to the left.

View 1 Replies View Related

Excel 2013 :: Chart Label Not Displaying?

Jun 8, 2014

I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount. I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?

View 2 Replies View Related

Excel 2007 :: Default Chart Size?

Jan 6, 2014

I have excel 2007 and I came across the following difficulty:

If I create a graph (or a chart) the default size is "Letter". However, I can switch this "Letter" to "A4" which I need and then create a template. But I always have to manually choose this template for new charts. However switching this any time I create a new chart is a rather bad way to cope with. Even clicking on set as default obviously does not cause to have A4 size for new chart, it still has got size of Letter when adding a new chart.

I assume the solution could be in XLStart templates, but it probably doesnt work for charts that you add. Or at least I didnt find any clue on the internet for this problem.

View 3 Replies View Related

Excel 2010 :: Create Percentage Bar Chart?

Mar 19, 2013

Im looking to create a bar chart in Excel 2010 where the totalnumber of widgets is 33 and the number produced so far is 11. The bar chart would be a single bar that represents the percentage complete (33%) with the chart maximum range being 100% which would represent the number 38.

Ive included a mock up example of what the data and chart would look like

View 3 Replies View Related

Excel 2007 :: Pie Chart Filled With One Color

Nov 7, 2011

I have a Pie Chart that which is updated based on a dropdown list.

The pie chart works fine for all my dropdown options - except one!

Basically, on this particular chart, the entire chart is filled with one colour even though the split is 90/43.

I am using Excel 2007. The options for Fill are set to Automatic & Vary Colors by slice is checked.

View 4 Replies View Related

Excel 2010 :: Labels For Legend In Chart?

Dec 16, 2011

I have a chart with 20 series labels that are series 1, series 2.... etc. I want to label them with 20 corresponding cells but can't find how to do this in Excel 2010 (I seem to remember this being easy to do in older versions). At the moment I am having to click on source data and edit each label individually... Is there a quicker way?

View 2 Replies View Related

Paste Excel Chart To PowerPoint Slide

Feb 19, 2012

For the chart in the excel worksheets, does anymore know who to copy it to the powerpoint slide with VBA? (either straight copy and paste, or copy and paste in as picture?)

View 4 Replies View Related

Excel Chart Data Validation List

Apr 24, 2012

I want to draw Excel chart Depending On chart Type I Filter From Data List In Cell H4 I & Change The Excel Chart Title Automatically To The Name Of Chart Type I Filter On

Sheet1

ABCDEFGHIJKL1TypeDatesValues 2Monthly01-01-2012319 3Monthly01-02-2012176 Chart 4Monthly01-03-2012356 Monthly 5Monthly01-04-2012317 6Monthly01-05-2012436 7Monthly01-06-2012461 8Monthly01-07-2012323 9Monthly01-08-2012417 10Weekly01-01-2012461 11Weekly08-01-2012279 12Weekly15-01-2012244 13Weekly22-01-2012190 14Weekly29-01-2012117 15Weekly05-02-2012202 16Weekly12-02-2012146 17Weekly19-02-2012422 18Daily01-01-2012195 19Daily02-01-2012354 20Daily03-01-2012357 21Daily04-01-2012354 22Daily05-01-2012289 23Daily06-01-2012205 24Daily07-01-2012371 25Daily08-01-2012304 26Daily09-01-2012496 27Daily10-01-2012307

View 7 Replies View Related

Excel 2010 :: For Mac - Putting Title On A Chart

Jul 31, 2012

How do I put a title on my chart, I'm using 2010 excel for mac.

View 2 Replies View Related

Illustrate / Animate Hydraulic RAM With Excel Chart?

Jan 10, 2013

how to illustrate/animate an hydraulic ram using an excel chart?

I've been working on a spreadsheet to do all the general hydarulic ram calculations and I thought it would be a nice feature to illustrate as much of it as possible.

I mainly want to show the stroke and angle the ram is tilted at; but if it was possible to actually show the ram detail, like the bore and rod that would be great.

View 2 Replies View Related

Excel 2007 :: Chart Created Using Name Ranges

Jan 28, 2013

I have built a chart using dynamic nameranges. The problem that I am facing is I tested it on two systems . One system the charts works fine but the other system the charts does not work . Both are excel 2007. Now the error that I get is if I see the chart data source from one system it is showing "!". The other file shows the chart data source as "0!". What should I be checking so that it works in the other system as well?

View 6 Replies View Related

Dates With Different Colour In X Axis In Excel Chart?

May 12, 2013

I want to draw a chart in Excel, in X axis Dates and in Y axis some other data. The dates which fall Saturday and Sunday will show in RED colour. Other dates will show in default colour.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved