Excel Chart
Nov 22, 2006Is 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, 2014I 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.
Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart
Nov 27, 2011I 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.
Excel 2003 :: Filter Data In Graph / Chart (without Having To Create New Chart)
Dec 29, 2011I 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.
Org Chart With Excel
Feb 20, 2009Hello 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.
How To Have Excel Select A Row From A Chart
Oct 11, 2013I 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 RelatedExcel Chart To Show Timeline?
Nov 23, 2011I 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?
Excel Chart Using OFFSET Function
Mar 14, 2012I 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.
Background Color In Excel Chart?
Jul 13, 2012How 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 RelatedExcel 2010 :: How To Create Bar Chart
Dec 26, 2012how 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.
Excel Macro For Charts In PIE Chart?
Jan 28, 2013i 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 RelatedExcel Chart - Defining X Axis Value
Mar 15, 2013Excel 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 RelatedCreating Word Chart From Excel Via VBA?
May 2, 2013I 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.
Excel Pivot / Regular Chart
Aug 13, 2013Basically 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] .......
Creating Excel Line Chart?
Mar 10, 2014My 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].....
Paste First Chart Into Second Chart But Maintain Format Of Second Chart?
Jul 12, 2013How do I paste the first chart into the second chart but maintain the format of the second chart?
View 2 Replies View RelatedExcel 2007 :: VBA To Insert Org Chart Object
Dec 24, 2011I 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 RelatedExcel 2010 :: Dynamic Line Chart
Jul 12, 2012I 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 RelatedHow To Control Individual Functions In Excel Chart
Apr 13, 2014All 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.
Excel 2013 :: Chart Label Not Displaying?
Jun 8, 2014I 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 RelatedExcel 2007 :: Default Chart Size?
Jan 6, 2014I 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.
Excel 2010 :: Create Percentage Bar Chart?
Mar 19, 2013Im 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
Excel 2007 :: Pie Chart Filled With One Color
Nov 7, 2011I 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.
Excel 2010 :: Labels For Legend In Chart?
Dec 16, 2011I 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 RelatedPaste Excel Chart To PowerPoint Slide
Feb 19, 2012For 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 RelatedExcel Chart Data Validation List
Apr 24, 2012I 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
Excel 2010 :: For Mac - Putting Title On A Chart
Jul 31, 2012How do I put a title on my chart, I'm using 2010 excel for mac.
View 2 Replies View RelatedIllustrate / Animate Hydraulic RAM With Excel Chart?
Jan 10, 2013how 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.
Excel 2007 :: Chart Created Using Name Ranges
Jan 28, 2013I 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 RelatedDates With Different Colour In X Axis In Excel Chart?
May 12, 2013I 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
