# Simple Line Chart With Buttons To Choose Datasets

Apr 19, 2014

I want to create a chart on a sheet. If I were charting one data set it would be real simple; I could do so by selecting the range of data values which are in a single column with the respective dates in another column and chart it with data on y, dates on x.

Each point was sampled on a day, only one point per day. I have a table for each person, one column has the data point, the other has the date it was sampled on. I would most like to pair each for not every person has a datapoint sampled on each day.

I have ten individuals with that metric (dataset based on the same sampling). I want to add and erase a line on one chart for any and each person by clicking a toggle button for that individual so we can do any comparative thought of.

## 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%

## This Simple 10 Line Code Doesn't Work If Just The Reference Is Changed..

Jun 10, 2009

I asked for a macro to delete the whole row if a duplicate customer number was found in column B. Sometimes, though, my column numbers change. So, logically thinking, I simply changed the criteria, but the macro ONLY seems to work if duplicate customer numbers are in column B only.

This code below won't work if the Customer Number is in column D instead of B even if the reference of B:B is changed to D:D, it doesn't carry the macro over.?

## Allow User To Choose Dates To Chart

Sep 12, 2006

selecting dates and data and makinga graph

and thought I could learn this one myself. I was wrong. Andy Pope came up with a nice little spreadsheet but I could not follow it (being a novice).

The problem is, I want the user to be able to input a start date and an end date and a graph to update automatically between these dates (for the x-axis) but also the y data adjust to suit.

The input cells are C23 and C30, and the 5 Y-axis data are the coloured columns.

I have attached a zip file with the excel spreadsheet inside.

## Allow User To Choose Range For Chart

Apr 29, 2008

I want to make a chart with the time in x axis and all of the S in the y axis. The problem is I want to be able to choose which S that I want to put in the chart. Example, I want to make 2 chart with S2,S3 and S5 in the first chart and S1 and S6 in the second chart. What I want is when I click the button 'chart', a pop-up appear and ask which S that I want to include in the chart.

## Making A Simple Chart

Jun 1, 2009

Im trying to create a bar chart that contains required hours per week with a line of hours worked going across the bars, im struggling to make this work and have basically no experience of making any sort of charts or graphs.

I need to create this using vba but to begin with I cant even make the chart manually! Where its all going wrong is the column line for required hours is so thin it looks rubbish. Its a bar chart then I formatted the series of total hours to be a line chart.

## Simple Scatter Chart

Jun 16, 2006

.ChartType = xlColumnClustered

plots a chart with stacked columns. So i was wondering what the chart type i should specify to get a simple scatter chart.

## 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.

## Adding Comparison Line Chart To And Existing Population Pyramid Chart

Jul 14, 2012

I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.

## Show Missing Values In Pivot Chart (line Chart) Axis?

Apr 18, 2013

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.

## Chart Type To Choose - Assign Particular Column To Particular Axis Only

Jan 16, 2014

I have a excel with data values in 5 different columns.

Column A: Time in seconds (1,2,3,4,5.... so on) continuously in equal intervals.

Column B: Values Generated by my machine at each second (random values)

Column C: Values generated based on column B using a formula (Let formula be denoted by " F ").

Column D: Highest possible value of calculation on column B (With +ve error consideration in formula "F")

Column E: Least possible value of calculation on column B (With -ve error consideration in formula "F")

Two graphs need to be generated as follows:

Graph 1:
X Axis: time values ( From Column A )
Y Axis: Corresponding machine generated values from Column B

Graph 2: Envelope
X Axis: time values ( From Column A )
Y Axis: Both value of column D & E ( Time value 1 sec has two corresponding values, one from Column D and one from Column E)

Both values of Column D and E be plotted and the area between two lines generated by upper limit and lower limit (Column D and E respectively)

So for both, what chart types should I select, and how do I assign that particular column to that particular axis only.

## Overlay Line Chart On Top Of Stacked Column Chart?

Feb 15, 2012

I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.

## Line Chart - 12 Month Chart Moving With Dates

Jan 22, 2008

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.

## Make Simple Chart Showing Angles

Feb 8, 2013

I'm trying to plot a chart of some sort in Excel to display 4 angles that different blood vessels branch off the aorta. Ideally I'd like to input the values of these angles which would vary from patient to patient and have them be displayed in some kind of chart. The chart I'm hoping to achieve would be cirular with the 4 angles represented by spokes which extend out all of the same length. I've attached a rough sketch to show what I'm trying to achieve and I'd be hoping to be able to change each angle in a worksheet and have the chart update to reflect.

## Unable To Create Simple Win / Loss Chart

Dec 4, 2012

I have a # of games played column (Column A), a # of games won column (Column B), and a number of games lost column (Column C).

I'm trying to make it so Column C automatically enters the number when I put in the number in Column B.

Example:

Games Played........Win........Loss
1.........................1...........0
2.........................1...........1
3.........................1...........2
4.........................2...........2

For the fifth game played, if I won it, how do i make the 2 to automatically enter into the loss column when I put in the number 3 in the win column?

## Pivot Chart Object: Find Any Suitable Object To Choose From To Make A Pivot Chart In Powerpoint

Mar 21, 2007

1) i have office 2003 on a laptop. within powerpoint, i can create a 'microsoft excel chart 11' object. to create a link to the excel data source, do i have to go through the odbc sql setup? it works, but i don't want my powerpoint to be dependent on some excel file somewhere. what are the other options to insert/make a functional pivot chart in powerpoint with the data also within powerpoint? the data as sheet option does not result in the chart being a pivot, it's just a plain chart. it has to be a proper object, not an image paste or a chart that updates links with the excel file open.

2) i have office 2007 on my other laptop. i can not find any suitable object to choose from to make a pivot chart in powerpoint. what's the best way to go about in 2007 version?

3) am i going about this the wrong way with the objects? should i be after vba code?

## Format Simple Graph Y Axis Of Pivot Chart?

Nov 19, 2013

I have a pivot chart which has one Axis field (Cell Ref2) and one Sum of Values field (which is a table series of percentages calculated from formulas)

I see the graph like I'd expect, but I'm struggling to get it to show percentages rather than basic integer units on the y-axis? Usually I would imagine to just right click on the y-axis : Format Axis, and expect to see something to change the display units, but it is only for hundredths thousands etc rather than a percentage ? The units themselves in the table for that value series are in percentages so I don't see why it isnt showing the percentage units in the first place.

## Column Chart With Line Chart And Percentage?

Sep 15, 2014

In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.

## Pareto Chart, Set Line Chart Origin At Zero

Nov 28, 2008

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.

## Line Chart To XY Chart And Vice-Versa

Feb 5, 2010

Attached is the sample data worksheet. Chart 1 is XY type chart using Seconds (2nd column of sample sheet as x-axis from 42510 to 42530). How do I change it to Line chart using Time (1st column of sample sheet as the X-axis) retaining same data from 42510 to 42530 on both primary and secondary axis?. And how do I again change it back to XY chart?

## A Chart Will Columns And A Line Chart Below??

Dec 15, 2007

I can create a column chart in excel comparing sales in 06 v's 07 for each month in 07, what I'm aiming to show on the chart is how sales have grown or not over a comparative period. A simple enough graph, I end up with about 24 columns (2 for each month and then a gap between each month).

I now want a line chart to show the performance of an index over the same time period, lets say the FTSE100.

I don't know how to get the line chart under the columns on the same graph, using the same x-axis with a small y-axis to the left. I could propably figure out the y-axis bit if I could only get the line chart below the columns.

## Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart

Nov 1, 2006

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.

## Select A Chart Type In A Userform Using Option Buttons

Jul 14, 2006

I have made a simple procedure (which will extend to make something that I have to make but for time being) it asks user to select a chart type in a userform using option buttons and then the chosen chart type is taken as the chart type and makes the chart.

problem is that the typechart - variable to identify the chosen chart type - is not being recognised. Here's the coding, the variable is not passed (in yellow bolded) from one procedure to another?

Private Sub NextButton_Click()
Call ShowType
If bFlag = False Then
MsgBox "Not Selected"
Call ShowType
Else
Call MakeChart
End If
End Sub

## Line Chart To Zero (VLookup)

Apr 7, 2014

I have a couple of charts getting their data from a vlookup formula, example,

=VLOOKUP(\$A\$8,CPPDATA!\$A\$4:\$O\$27,5,FALSE).

I really need to prevent this from happening. I'm sure there is a way.

see image

[URL]

## 0 Value On Both X And Y Axis In Line Chart How

Jan 4, 2008

i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs

## How Do I Not Graph A 0 Value On A Line Chart

Oct 26, 2009

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?

## Line/candlestick Chart

Apr 28, 2007

I am trying to graph a candle stick chart but also have a series which is a line in the graph. I have attached the file. I am trying to figure out how to get get column E as a line in this graph.

## R Squared In Line Chart

Jul 27, 2007

Hi, as you can see in this chart I am plotting TOTAL company sales against its three merchandise components - men's, women's, and accessories. My issue is that when I had two rows to just show company sales against one of the merchandise categories -- and I Go TO TRENDLINE and show the R-Squared, it is ALWAYS THE SAME= 20%. CLEARLY, something is wrong beacuse (a) its different numbers for each of the three merchandise categories and (b) these three categories make up the total comp so CLEARLY it should be a higher R-squared than 20%. How Can I get it to properly read the R-Square.

## Bar-line Combination Chart

Sep 28, 2007

I have a table with 7 rows and 7 columns:

First 6 rows - months i.e. Mar to Aug
7th row - Average no. of Breakdowns

Colums - Mon to Sun

I am trying to create a bar-line chart with the 'Average No. of Breakdowns' to be on the 2nd Y-axis and displayed as a line.
The rest of the data would be on the primary Y-axis and displayed as bars,

But I am unable to get what I want. Instead, the data on the 5th and 6th row is displayed as lines. I even tried formatting these 2 rows to the primary Y-axis but they are still displayed as lines.

## Add Line To Chart To See Trend

Dec 5, 2007

On top of these graphs, i draw a line (insert a line shape) corresponding to a certain gradient in the data presented. I do not want this line to be exact (i.e. not point to point) as it is best to be drawn by eye so that the general 'gist' of the data can be found. What i would like, using any method available, is to be able to find the gradient of this line i have just drawn which obviosuly must be done taking into account the scale of the graph. The scales of the graph will not be consistent across all applications.