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


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 2007 :: Dynamic Colors In Line Chart

Dec 9, 2013

I have a line charts with values above and below zero.

Im looking for a way to colour the steps below zero in one colour, and above zero in another colour - without doing it manually.

Using Excel 2007.

View 1 Replies View Related

Excel 2010 :: Adding Horizontal Line In Chart?

Oct 11, 2011

I want to a horizontal line in a chart. There are only two figures with me. One I want to display as a column chart. The other as a horizontal line chart. (I can use both excel 2003 or 2010, whichever is suitable)

View 2 Replies View Related

Excel 2010 :: Chart - Clustered Column With Line

Jun 9, 2014

I would like to be able to add a line (a trend line) to a clustered column chart. The attached jpg (picture copied from Excel Charts - Easy Excel Tutorial) shows the general structure, with the red (poorly) hand drawn lines representing what I want to add to the chart.

If using Excel's Trend line functionality is not an option, I have already calculated the trend points adequately, so have the data to add as an additional series or combine with an existing series. (using Excel 2010)

View 3 Replies View Related

Excel 2010 :: Ongoing Line Or Scatter Chart Don't Want Bar To Drop To Zero On Blanks

Jan 29, 2014

I'm using Excel 2010

I'm working on a workbook for tracking debt. It has 15 sheets. Instructions, Charts (for showing debt change over time), "Invisible" (this is where my chart data is, I plan to hide it), and 12 month sheets. On the Invisible sheet, for example, I have my data set up. I'm pulling the data from other sheets. In the screenshot, I'm using =Month12!P48 as the formula to pull my data from the other sheets. But, the user hasn't entered data yet for month 12, so the line chart drops to zero there. I want it to just stop and do nothing, until there is data in that cell. (I would prefer to use a line chart vs a scatter chart for this, but I have the same problem in both)


View 2 Replies View Related

Line Chart From Dynamic Range Of Data

Feb 14, 2014

I have a spreadsheet that I have setup to have raw data pasted into. Long story short, it pulls the maximum reading for a given 5 minute period and returns the highest value for each 5 minute increment where there was a reading. It does this for all of the different dates entered, returning a separate data table for each date.

What I now need is to graph the data on a line chart. Since the number of time values can be variable, I have to include the entire range (for example A3:B5002). When I graph this out, it has all of the data clumped up at the beginning and flatlines for 99% of the chart.

I tried building dynamic named ranges using offset, but that seems to yield similar results once charted.

See the link below where I've dumped some sample data in (it wouldn't let me upload due to the size and I can't upload only part of it without breaking the whole thing). The data I need to chart is from columns A&B on the GraphData sheet. Sheet 1 contains the chart I have been trying to use. The endgame of this is to have the end user paste in their data and *POOF* charts.

My only restriction is that I cannot have Macros/VBA.


I tried following this post and using NA() instead of ""...no dice, it just puts #NA at the bottom labels instead of spaces.

View 3 Replies View Related

Offset Formula - Creating Dynamic Line Chart

May 28, 2014

I am trying to create a dynamic Excel line chart.

All is well, except for my x-axis (which is a text axis). It currently looks like this: Dynamic axis.jpg

I am using the Offset formula. The formula for my x-axis is =OFFSET(Worksheet1!$D$4,0,-3,COUNT(Worksheet1!$D$4:$D$36)). This is to show the axis if cells in Column D are filled up appropriately.

However, in the cells containing the axis name itself, this formula is used =IF(D9=0,NA(),'Worksheet2'!A6). I've tried removing the formula from these cell, but that didn't solve the problem.

View 5 Replies View Related

Excel 2010 :: Insert A Line Every 4th Line?

Nov 29, 2013

I have a spread sheet with product codes on and 5 different prices types but they have only pulled through 4 times so need to insert a 5th line for each product code

View 2 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



View 9 Replies View Related

Excel 2010 :: Add Comma To The End Of Line In Cell?

Jan 25, 2013

i have 5000+ addresses with no punctuation in them, just seperated by line breaks. i need to be able to add a delimiter (semi-colon, colon, full stop, any will do) to the end of every line of the address, not the cell; in order to extract the info using 'Text To Columns' in Excel 2010

View 9 Replies View Related

Excel 2010 :: Loop Through Every Line On Sheet?

Sep 30, 2013

How can I get this code to loop through every line on sheet?


Cells.Find(What:="Part Number", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

[Code] ..........

View 2 Replies View Related

Excel 2003 :: Add Horizontal Line To Stock Chart?

Feb 25, 2011

I am using the the stock chart and I would like there to be a horizontal line across the chart with a y-axis of the opening price. In the end I want this to be in VBA but how to do this manually I should be able to put it in loop of data that will produce many charts with a horizontal line starting at the day opening.

I have tried to add a new series to the chart but I'm using the Candle stick stock chart and the new series comes out as a vertical not horizontal line. I read about using a secondary horizontal axis but all the tutorials I find are in Excel 2003 and they donlt line up well with Excel 2007.

I found this link on charts with horizontal lines but again they are in 2003 and I'm using a candle stick stock chart not a scatter chart. [URL]

View 6 Replies View Related

Excel 2010 :: Line Graph Isn't Charting Lines?

Feb 23, 2012

I have been trying to chart temperature differences over 10 day's time for six cities using a line graph. For some reason, the lines are all clustered at the bottom of my graph, with values of 0. My spreadsheet is accurate, without any blank cells. I'm using Excel 2010.

View 1 Replies View Related

Excel 2010 :: Creating Charts With Average Line?

Apr 5, 2012

How I could create a chart (standard column) with an average line in Excel 2010?

View 4 Replies View Related

Excel 2010 :: How To Make Line Graph With Categories On Y-axis

Jun 26, 2014

I have been given a task to create a line graph who has 10 categories and each category has 5 different values. I need to plot a line graph, so that those 10 categories should appear on the Y-axis instead of X-axis.

I am using Excel 2010.

View 8 Replies View Related

Excel 2010 :: Creating A Simple Line Marker Graph?

Mar 2, 2014

I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:

Seperation First target Second target
0 59.00% 0.00%
2 64.28% 40.62%
4 62.68% 48.99%
6 60.81% 65.83%
8 61.82% 70.21%

View 6 Replies View Related

Excel 2010 :: Message Box Request When Cell Is Completed And New Line Added?

Mar 27, 2014


I attached the sheet that I am trying to get up and running, there is two things I need to do, but cant get it working as I intend to.

Sheet 1 - When the invoice number is fulled in in cell F8 a message box must pop up requesting the hyperlink to the invoice saved on a share folder, but for now on the desktop, when the file is selected it (the hyperlink) must be returned to cell G8, then once the last cell (I8) has been completed, the line 8 must be locked so that it can't be editted again without a default password and a new line must be added below line 8 for processing, I tried recording the macro, but it only works on one line, and on the message box request, I truly am not up to speed yet, this I can't get up and running.

Excel 2010

View 2 Replies View Related

Excel 2010 :: Calculating Coordinates For A Point On Multi-Segment 3D Line

Sep 19, 2013

Windows 8, Excel 2010

I have XYZ Coordinates for a continuous 3-D line that has numerous segments. I want to input a distance along that line, and have it create the XYZ coordinates at that point. See Image for reference.

Row 2 is my start point - I input the initial coordinates here - this point is the origin of the 3-D line
Column B is where I want the calculated Y value to go for each point
Column C is where I want the calculated X value to go
Column D is where I want the calculated Z Value to go
Column E is the how far along the 3-D line that the (to be calculated) point should be at. (MD1)
Columns G, H, & I are given to me, and I use this data to generate the coordinates in Columns J, K, & L
Column O is the cumulative length of the line at that coordinate. (MD2)

Basically, I had planned on writing a formula to:

Find the coordinates of the point who's MD2 (column O) is before the desired point's MD1 (column E)Find the coordinates of the point who's MD2 (column O) is after the desired point's MD1 (column E)Subtract MD's (column O) to get the length of the segmentFind the distance along that segment that MD1 (column E) fallsUse that distance to traverse along that line to the desired point.

View 1 Replies View Related

Excel 2010 :: Dragging Page Break Line Creates Many Pages?

Jan 15, 2014

Why when I drag the dotted blue page break line does it sometimes break the entire doc into one page per cell ?

The doc is not wide. When I first load I can drag the break line successfully. Then I print preview... select print on both sides... boom.. goes from 4 pages to 14. Then I go back to page break view... drag the line... boom... Hundreds of pages. Even if I revert back to printing on one side it still is messed up.

How do I make this stop?? What am I doing wrong?? Office 2010

View 1 Replies View Related

Excel 2010 :: Macro To Delete Last Line Of Data In Each Worksheet In Workbook?

Apr 24, 2014

I'm trying to create a macro that will look at each worksheet in a workbook and then delete the last line of data on each worksheet. The last row can vary on each worksheet. This is what I have come up with but it is not working. I am on Excel 2010 and Windows 7.

Sub Macro1()
Macro1 Macro
Dim ws As Worksheet


View 2 Replies View Related

Excel 2010 :: Pivot Dynamic Name Range?

Jan 27, 2013

I am trying to insert a Pivot table with dynamic Name Ranges. It needs to start from Cell B1 as Column A has hidden formulas in them. I created an Dynamic Name range and tried to insert a pivot table. Excel then throws out a error stating "Data source reference is not valid". I tried re-saving the document but still no luck.

View 1 Replies View Related

Excel 2010 :: VBA - Open Sheet With Dynamic Name?

Nov 25, 2013

I have this workbook in which each sheet refers to a month in a specific year (e.g. Jan12, Nov13), plus an "overall" sheet where I would like to, among other stuff, create a button that would lead me to the sheet refering to "today's month".

Although I know how to create a "static" macro that leads me to a particular sheet, I don't know how to create one in which the sheet it refers to is changing every single month.

(Note: I'm using Win7, MSExcel 2010)

View 6 Replies View Related

Excel 2003 :: Dynamic Chart For Test Scores

Jun 5, 2014

I have 3 test scores for each student. Currently, I have 3 students.

For example :

John 95 90 85
Cindy 50 60 100
Dan 87 86 90

I have a chart that that plots 3 lines, one for each student.

However, I want the chart to dynamically update if there's another student. In other words, I would like the chart to add another series while the legend updates to include another student.

I am trying to do this in Excel 2003.

View 2 Replies View Related

Excel 2010 :: Dynamic Dropdown List Of Dates?

Aug 9, 2013

I'm trying to create a set of three dynamic/dependent drop down lists of date values, based on a set of imported data. Depending on whether the preferred choice is to list all dates in a range or just dates on the 15th, the available start and end drop down lists will change.

In addition, if possible I would then like to display a list of valid dates (not sure if this needs to be VBA).

The attached sheet shows/explains what I am attempting but here it is as well:

If B3 is set to show all dates in the month then:

the first dropdown option for C3 will be the first date of IMPORT (D2)
the first dropdown option for C4 will be the C3 value, to the last date in IMPORT (D) column

If B3 is set to show 15th of the month then:

the dropdown for C3 will be the first date of IMPORT (D) column with a date of 15th the dropdown for C4 will be in the range of C3 to the last date of IMPORT (D) column with a date of 15th only dates of 15th will be listed in both C3 and C4 dropdownlists


the dates in IMPORT column D are taken from IMPORT column A, B & C, which will be imported and will always be date sequential the number of rows of date entries will change with every import but there will never be any blank rows between dates the values in IMPORT columns A, B & C will always be numerical, and can be referenced if required [ideally] the LIST OF DATES will be populated with the date range, based on the option selected in B3

I'm fairly familiar with Excel (2010) and I have also done some VBA but I'm new to dynamic, nested dropdown lists and I'm unsure what the most practical way is to achieve this.

View 1 Replies View Related

Excel 2010 :: Condensing VBA Code - Using Dynamic Variables?

Jul 17, 2012

I have some VBA that dumps various sheets data into an SQL Database.

Part of that requires me to sanitize all of the fields before they make it to the DB, (at least to prevent the code from breaking itself w/ errant ' characters.

right now my code is as follows

If InStr(aa, "'") > 0 Then
aa = Replace(aa, "'", "''")
End If
If InStr(bb, "'") > 0 Then
bb = Replace(bb, "'", "''")

[Code] ......

I was hoping to condense it to something like the following, however it is not working how I hoped / want it to. .. I had found somewhere out there that this Eval() function possibly could be used to 'reference' dynamic variables, however it does not appear to work at all anymore, and even then it may only have worked to 'read' and not 'write' to the variable. (Excel 2010, on Windows 7 64-bit).

itemsToSanitize = "aa,bb,cc,dd,ee,ff,gg,hh,ii,jj,kk,ll,mm,nn,oo,pp,qq,rr,ss,tt,uu,vv,ww,xx,yy,zz,aaa,bbb,ccc,ddd,eee,fff,ggg,hhh"
ITSArray = Split(itemsToSanitize, ",")

For Each thing In ITSArray
If InStr(Eval(thing), "'") > 0 Then
Eval(thing) = Replace(Eval(thing), "'", "''")
End If
Next thing

View 7 Replies View Related

Excel 2010 :: Dynamic Range Not Working Properly

Jan 8, 2013

Had been using this formula for almost 3 years, recently the formula didn't work properly as the range goes down halfway only instead of to the last data in the column. I'm using Excel 2010 now.


View 2 Replies View Related

Excel 2010 :: Dynamic Range In The Middle Of Worksheet

Oct 27, 2013

how to use the offset function to create a dynamic range in Excel 2010. An in-house Excel form I work with spans columns A thru P and has three sections. In Section 2 the user fills in employees who are requesting to work overtime. Section 2 starts row 12 and ends row 61. It's sometimes necessary to add rows to this section. How do I make this section/range dynamic using the offset function?

View 1 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 2010 :: Dynamic Changing Of Series Collection Values?

Jul 6, 2014

I still get the 'Object doesn't support this property or method. Error code 438' error. I am using Excel 2010

j = 3
Do Until j = 6
Set chartX = ActiveSheet.ChartObjects("X")


The macro is supposed to dynamicaly adjust series range for 3 charts for x,y,z, values in each of sheets. Charts are a line type.

View 3 Replies View Related

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