Solved

add lines & higlite specific area to line chart

Posted on 2014-11-30
13
129 Views
Last Modified: 2014-12-05
hi
i have data of sales like this :
A2:A50 branches names
B1:AL1 periods
B2:AL50 sales values
the questions are :
1- what is easiest way to do line chart for each period series for each branch else of copiyng it many times ?
2- i select line chart , how to add columns between period labels & series value on the line ?
3-how to  highlight specific period on the chart
0
Comment
Question by:NiceMan331
  • 7
  • 6
13 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40472883
Hello,

1. Use a pivot chart. You will see drop-downs in the pivot chart to filter the data

2. I don't understand what you want to achieve. Please post a file with some sample data. Draw the desired result with the drawing tools, so we can see what you want.

3. Highlighting can be done in many different ways. Again, it depends on what you want.

Post some sample data and mock up the charts.

cheers, teylyn
0
 

Author Comment

by:NiceMan331
ID: 40473208
THANX
1- how to use the pivot chart ?
2- look at the attached file , you will see that i need to draw columns ( in black ) between the value and the period value
3- look at the highligted yellow area , i need something like this
CHART.png
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40473229
I see a pretty picture (or maybe not so pretty).

With charts, everything (as in EVERYTHING) depends on the data. Without the data, there is no chart.

That's why I asked you above to post a file with sample data and mock up a chart that relates to that data.

An image of the chart does not help, unless you post the data that will be used to create the chart.

So, please post that.

cheers, teylyn
0
 

Author Comment

by:NiceMan331
ID: 40473260
here a sample file
chart.xlsx
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 40474950
Hello again,

If you want to select which branch to show in the chart, you need a cell where you select the branch, then use a formula to pull that branch's data into a helper table. Create the chart from the helper table that has only one row of data.

With a line chart, you can use the ribbon Chart Tools > Layouts > Lines (in Analysis group) > Drop Lines.

See the chart in the attached file.

To fill an area below the line, you need to use a technique described in a tutorial by Jon Peltier here:

http://peltiertech.com/fill-under-between-series-in-excel-chart/

cheers, teylyn
chart--1-.xlsx
0
 

Author Comment

by:NiceMan331
ID: 40475284
good
how to add series value in the chart for each point as per my 1st file ?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40475390
Sorry, I don't understand. What is your first file? The image? The Excel file? And what do you mean with "how to add series value in the chart for each point" ?

Can you explain with a few more words?
0
 

Author Comment

by:NiceMan331
ID: 40475736
YES
please look at my excell or eighther the image i sent first
you will see on the line , value for each point
this one i want to add it to your excell file
is it clear ?
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40477364
Oh, I see. These are called data labels. You can turn them off or on for each series. In Excel 2010, click the series in the chart and on the Chart Tools ribbon select the Layout tab, then Data Labels. In Excel 2013 select the series and click the + button next to the chart and then Data Labels.
0
 

Author Comment

by:NiceMan331
ID: 40478209
i have excel 2007
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40480295
Hello again,

short answer:

The steps in 2007 are the same as for 2010

Longer answer:

this is the first time you mention your Excel version. Maybe you want to put that into your question next time. There are significant differences between 2003, 2007, 2010 and 2013.  You can help people answer your question faster if you let them know which version you are using.

If you find a suggestion that does not have YOUR VERSION stamped on it, you could at least try it.

You will find that one of the two suggestions I posted works for your version.
0
 

Author Comment

by:NiceMan331
ID: 40484279
click the series in the chart and on the Chart Tools ribbon select the Layout tab, then Data Labels
sorry , i can't find this : Chart Tools ribbon
any image for it ?
thanx
0
 

Author Comment

by:NiceMan331
ID: 40484282
yes , i got it
thanx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Customer Filter on Text file 4 36
Win7/Excel 2016 crashing 1 218
Excel 2010 Slicer Issue 3 49
Trying to populate a summary worksheet in excel from another worksheet 14 82
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now