Avatar of NiceMan331
NiceMan331
 asked on

add lines & higlite specific area to line chart

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
Spreadsheets

Avatar of undefined
Last Comment
NiceMan331

8/22/2022 - Mon
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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
NiceMan331

ASKER
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
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
NiceMan331

ASKER
here a sample file
chart.xlsx
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
NiceMan331

ASKER
good
how to add series value in the chart for each point as per my 1st file ?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
NiceMan331

ASKER
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 ?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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

ASKER
i have excel 2007
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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

ASKER
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
NiceMan331

ASKER
yes , i got it
thanx
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.