How To Add Series Without The Graph Line

Apr 14, 2014

Is there any possible to add a series to a graph table without having the line in the Graph. i just want to show the difference for information and not in the graph?

i have tried some different things (like having the difference in white so it is not visible, formatting the Axis etc)

See attached picture. Excel 2.JPG

View 4 Replies


ADVERTISEMENT

Select Series (lines) In Line Graph By Adding Userform With Checkboxes On A Chart

Apr 15, 2014

I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?

View 2 Replies View Related

Create Line Graph That Will Incorporate Multiple Columns Of Data In One Series Of Data

Sep 27, 2011

I am trying to create a line graph that will incorporate multiple columns of data in one series of data. The reason I do not place all of the data in one column is because it could exceed the maximum amount of rows allowed in excel. Also I need the data split up for viewing purposes.

I can easily just graph one column but how do I combine all the columns into one line graph with the data being in separate columns. Basically all the columns will be my Y values and X values are just 1:n.

Example Below:

Column AColumn B Column C159261037114812

Now in the example all of the values are x values.

View 2 Replies View Related

Line Graph: (line Graph To Display An Amount Over Time)

Dec 30, 2008

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

Line Chart - Remove Series Code But What If No Series Exists?

Dec 22, 2011

I have the following code:

Sub Macro5()
ActiveSheet.ChartObjects("Chart 243").Activate
ActiveSheet.ChartObjects("Chart 243").Activate
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SeriesCollection(2).Delete
End Sub

However, if there is no SereisCollection(1) actually present in the chart I get an error. How can I work around this? I will need an IF statement I assume, just not sure what it will look like.

View 4 Replies View Related

Line Graph Not To Continue The Line If There Is Nothing In Row 10 Of The Table

Nov 6, 2009

With the attached spreadsheet i cannot workout how with the line graph not to continue the line if there is nothing in row 10 of the table.

for eaxmple if there is no value in cell M10, i would like the actual addtion line to stop at the last value on the graph that was in L10.

View 4 Replies View Related

How To Change Line Thickness In Line Graph

May 21, 2010

I have a chart sheet with a line graph that contains two series: I want to change their thickness, but I am not able to format it with VBA.

View 6 Replies View Related

Dynamic Series For A Graph

Jun 30, 2014

I have a graph that auto updates but sometimes there is only 1 series and sometimes there is 2,3,4, or 5 series. Is there a way to have the graph update accordingly? and only have have the series that are valid be in the key on the graph. Currently the graph keeps all the series in the key even when there isn't any data for it.

Please see attachment. Use sheet 2 for the graph. and use the drop down menu to select catagory. this ia very quick mock up of the concept.

Graphseries.xlsx

View 4 Replies View Related

Deleting All Series In Graph Using Macro..

Oct 26, 2008

I want to delete all series which are in graphs. is there any way so that i can pull total number of series in VB from graph, and then just do all the series one by one.

View 2 Replies View Related

Graph Data Series With Different Colours

Feb 21, 2007

I am creating a timeline using a stacked bar graph. The 3 colums in the source spreadsheet are title,start time and duration. The Two data series are start time and duration. I hide the start time series to give me timelines for each row in the spreadsheet. This works fine. What I'd like to do is to group the rows by title and distinguish by colour in the duration series but this doesn;t seem possible? I hope I've made myself clear.

View 4 Replies View Related

Conditional Formatting For Series On Graph

Oct 23, 2007

I have a table which provides the source data for a Bar Chart style graph. I need the colour of the different Bars to change depending on the values in the table. For example. If the value is over 1% then the bar will change to the colour Red otherwise it will stay Green.

View 3 Replies View Related

Multiple Series Chart/Graph

May 15, 2008

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 9 Replies View Related

Avoiding Display Of Empty Series In Graph

Apr 3, 2007

How can I avoid that an empty series shows up in the legend of a graph?

View 9 Replies View Related

Plot Multiple Series In 1 Graph/Chart

Aug 18, 2006

how can i plot multiple series of values in one graph after checking some check boxes, which i have previously done, randomly?

View 4 Replies View Related

Setting Graph Series Value Formulas Based On Other Dependencies?

Aug 29, 2012

A line graph is using a data row to plot the line; works fine. The data series ranges have been named for Week1 (H10), Week1_2 (H10:I10), Week1_3 (H10:J10), Week1_4 (H10:K10), Week1_5 (H10:L10), Week1_6 (H10:M10), Week1_7 (H10:N10), ...etc.

This is the data series formula name example to plot the data series from week 1 through week 7; ='Product Plan Q3 Week 7.xlsx'!Q3Wk1_7.

The series name formula Q3Wk1_7 for week 1 through week 7 is =$H$10:$N$10.

When this name is manually entered as a Series Value for the line graph, the graph plots exactly the way it is expected. The same is true if the Series Value is manually modified for some other ranges such as Week 1 through Week 9 (='Product Plan Q3 Week 7.xlsx'!Q3Wk1_9).

My challenge is to enter this Series Value based on the manually entered week number elsewhere; i.e., we're in week 7, the Series Value should be ='Product Plan Q3 Week 7.xlsx'!Q3Wk1_7. I've been trying to use an HLOOKUP table to select the correct Series Value formula based on the week number. The HLOOKUP works fine resulting in selecting the correct formula. I can also Name the range of data I want to graph and copy the name into the Series Value field with successful results. How do I get such a formula or Named range into the Series Value field without type it in? I want to set that Series Value to a range or name without having to select the line to manually enter the value.

View 3 Replies View Related

Source Location/Address Of Series In Graph/Chart

Apr 23, 2008

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 3 Replies View Related

Determine Half-Way Point Of Bar Series On Bar Chart/Graph

May 30, 2008

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 7 Replies View Related

Macro: Plot Graph/Chart By Series Of Rows

Jun 30, 2008

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 4 Replies View Related

Series Line Disappeared

Oct 10, 2006

I have a chart of type 'Line' that shows a KPI item measured quarterely. It has a single series that references the 'data' worksheet. Since it is measured quarterely, the months in between will have a null value. It has been working to date, but since I have added the data for the latest month, the series line has disappeared. Only the markers remain. The series line is formatted in a vivid blue.
I can't attach the spreadsheet because its 152KB. One thing of note is that when I select the series line, not all of the markers get highlighted as expected

View 2 Replies View Related

Adding Line To Bar Graph?

Jan 20, 2014

I am trying to recreate the screen grab that I have copied and pasted in (purple bar chart). I am to create the bar chart, but I am unsure how to create the dotted line which is the national average.

View 3 Replies View Related

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?

View 9 Replies View Related

Stacked Bar & Line Graph

Sep 20, 2006

how to create a stacked bar & line graph together.

I know by default, I can choose to have a stacked bar, OR a line graph, OR a basic bar & line graph.

But I need to take a step further and have a stacked bar WITH a line graph.

options in which I could combine the above graphs?

View 4 Replies View Related

Formatting Line Graph

Feb 15, 2007

how to have different format on a line grapgh. I have a series of data points for sales figures. The first 10 are actual data and the next 5 are projections. I want to have a line graph with solid color format for the actuals and a dashed format for the projections.

View 3 Replies View Related

Excel 2010 :: Dynamic Graph Creation Using The Series And Offset Functions?

Jan 7, 2014

I am in the process of setting up some graphs. The graphs will show the last 6 months of data so they move as each month is goes. I saw a slick way of doing this using the count function but this did not quite fulfill my needs. What I was looking for is to be able to input the start month in a cell. The cell would be part of the function within the formula. I created a simplified version of the spreadsheet below.

Spreadsheet.jpg

Then I created my names using the ctrl-F3

Names.jpg

I then created the graph I wanted and wanted to use the formula =SERIES(Sheet1!$B$3,!chtCat,!chtIssuesReported,1). This kept getting an error indicated nothing really. It basically says there is something wrong with my Series function. I have a working version of a similiar worksheet I have been basing my entries on. They look almost identical but mine is failing. I also created a new file and tried this and it still fails. I can run the formula evaluator within Excel 2010 against the !chtCat and !chtIssuesReported names and they both return the correct value (which equals areas on the spreadsheet). I have also tried to enter the spreadsheet name and a tab in front of the names to get them to work and still get an error. Basicall I am trying to create the graph below (this grpah is using the hard coded locations)

Graph.jpg

View 2 Replies View Related

Series Line Not Correct After Split

Apr 16, 2014

I'm using this code to split a series line into 2 overlapping parts, so I can use different styles on them:

Code:

Sub backfillDataSeries()
'make new series in Port Historical Risk
'if there is a backfill date in Rolling window data
Dim cRange As Range
Dim i As Integer

[Code]....

This is how the line looks before I run the code:

And this is how it looks afterwards:

I think it prints mirrored. Can I get a mirror image of the 2nd line?

View 2 Replies View Related

Make Line Chart From 3 Series

Jan 8, 2010

I have data:

Jan Feb Mar Apr May
2009years 56 45 42 50 62 - series1
2010years 48 47 45 48 55 - series2

I need make line chart from 3 series. First two are series1 and series2. Third is percent change between 2010 and 2009 years every month (series3). First two are easy, but third is very difficult for me, becouse I haven't row with percent change and I can't haven't it in my exercise.

How can I make it without new row with percent change?

I tried it with Data Source in chart, also formula in Name Manager, but it doesn't succeed

View 9 Replies View Related

Line Graph With 2 Lines Per Person?

Sep 15, 2013

I need to create a line graph that has 2 lines for each person, one with the amount, one with the points. The X-Axis is by Weeks going up. How can I do this without making a separate series for each? I've attached an example.

example.xlsx

View 1 Replies View Related

Stacked Bar Graph With Average Line

Mar 24, 2009

We are trying to create a stacked bar graph with an average line. Each time we try to add in the average data to the graph it adds it to the stacked bar. The stacked bar should represent the inpatient & outpatient cases at a hospital for the current year (months showing across the as columns). The line should represent the previous 2-yr average total. Anyone have an idea how to add a line to the stacked bar graph? It has us stumped.

View 3 Replies View Related

Line Graph In Descending Order

Dec 8, 2009

How do i achieve the graph that is on the pdf with the data in the workbook i've attached. i cant work it out?

View 2 Replies View Related

Shade In Area Under Line Graph?

Dec 1, 2011

What's the best way to shade in the area under a line graph?

View 1 Replies View Related







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