Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I need help changing a line chart in an excel

I need help changing...

I need help changing a line chart in an excel spreadsheet....

Technician's Assistant: When did you last update Excel?

Unknown I am not in the IT dpeartment....

Technician's Assistant: What have you tried so far with your Excel?

Tried every way I knew of to reassign column data to a line on a line chart5

Technician's Assistant: Anything else you want the Software Expert to know before I connect you?

Thats it....

Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 20 minutes by:
3/10/2018
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,217
Experience: 20 years experience providing remote computer support
Verified

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

can you send your file and explain what you want changed?

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,217
Experience: 20 years experience providing remote computer support
Verified
The-PC-Guy and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 5 months ago
I just need the line graphs fixed....
Both Charts - Y Axis = 0->600000 / X Axis = Jan -> Dec / Fixed Black Horizontal Line at 165000
Top Chart
Data / Line Legend = S/O 2017 ( cell B3 )
Data = B5->B16
Data / Line Legend = S/O 2017 Est. at 42% GP ( cells C3+C4 )
Data = C5->C16
Data / Line Legend = S/O 2018 ( cell D3 )
Data = D5->D16
Data / Line Legend = S/O 2018 Est. at 42% GP ( cells E3+E4 )
Data = E5->E16
Bottom Chart
Data / Line Legend = Invoices 2017 ( cell G3 )
Data = G5->G16
Data / Line Legend = Invoices 2017 GP ( cell H3 )
Data = H5->H16
Data / Line Legend = Invoices 2018 ( cell I3 )
Data = I5->I16
Data / Line Legend = Invoices 2018 ( cell J3 )
Data = J5->J16
Is this clear?
- Joe / ***@******.***

is this what you wanted?

Ask Your Own Microsoft Office Question

did you need remote support?

Or is this sufficient?

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
Great 1st pass.
A few errors on bottom chart only....
Bottom Chart
Data / Line Legend = Invoices 2017 ( cell G3 ) = CORRECT
Data = G5->G16 = CORRECT
Data / Line Legend = Invoices 2017 GP ( cell H3 ) = INCORRECT + Should be blue dashed line
Data = H5->H16 = INCORRECT + Should be blue dashed line
Data / Line Legend = Invoices 2018 ( cell I3 ) = INCORRECT + Should be green line
Data = I5->I16 = INCORRECT + Should be green line
Data / Line Legend = Invoices 2018 ( cell J3 ) = INCORRECT + Should be green dashed line
Data = J5->J16 = INCORRECT + Should be green dashed line
Customer reply replied 5 months ago
I'll hold for your 2nd try on this chart and we can determine then if I need remote assistance. OK?
Thanks. - Joe

i didn't really pay any attention to coloros

Ask Your Own Microsoft Office Question

try this

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
The charts look great and chart data is where it needs to go.
One last item you missed....
From 1st email -> "Both Charts - Y Axis = 0->600000 / X Axis = Jan -> Dec / Fixed Black Horizontal Line at 165000"
I need the fixed solid black horizontal line on both graphs at the value $165,000
That should wrap it up.
- Joe
PS - Do you do work out of justanswer.com?

i am just a consultant, trying to make a living.

Ok I don;t understand what you are asking for now.

If you download and install teamviewer we can do a remote. you can show me what you are talking about.;

https://www.teamviewer.us/teamviewer-automatic-download/

say it is for personal use if they ask, let me know when it is installed and running

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
i need your partner id....

i actually will need ur ID and password ***** connect

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
697 207 801 / 3979

give me a minute

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
OK....
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,217
2,217 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,217 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
Need 2 simple line charts in excel - easy task. 2 line
2 line charts:Chart 1: Horizontal axis: Dec, Jan, Feb, Mar, Apr, May Vertical axis: 815 million, 818mm, 820, 825, 830, 838mm Intervals, 1 million Start at 815mm and end 850mmChart 2: Same as one but with 5 mill intervals … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a pivot table with dates in the first column and
I have a pivot table with dates in the first column and categories in the other columns. The data in the chart is "count of" for the categories. In the first column, I grouped the dates by quarter and… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Creating a Pareto Chart in Excel 2016 This is my first time
Hello - Creating a Pareto Chart in Excel 2016 This is my first time attempting something like this … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,217 satisfied customers
2013 MS Excel: I'm trying to create line charts from a
2013 MS Excel: I'm trying to create line charts from a worksheet. It's an accounting spreadsheet to show comparative balance sheet items from year to year. I need to select specific non-contiguous cel… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I need help with creating and showing a secondary horizontal
I need help with creating and showing a secondary horizontal axis. I want to label a time on the lower axis and a date on the top axis. I have both these values in columns in the spreadsheet. Please h… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I need to build a dynamic chart - x axis EBITDA, Y axis 1
i need to build a dynamic chart - x axis EBITDA, Y axis 1 Multiples, Y2 axis Payout. i have the data and a picture of what i want to do but lack the skills to create it - help.… read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
792 satisfied customers
I was building a nice presentation after importing data .csv
i was building a nice presentation after importing data .csv into Excel. i saved often and a dialog box asked do you really want to save .csv and I said yes. after several hours of tables and pivot ch… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have been trying to construct stograms, frequency curves
I have been trying to construct histograms, frequency curves and cumulative frequency curves (charts/graphs) to show grain-size distributions of sand grain samples (500 grams) randomly collected from … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
How do you take a block of cells that have 12 rows and 52
how do you take a block of cells that have 12 rows and 52 columns and change them to 52 rows and 12 columns?… read more
R. Michael
R. Michael
MIS Analyst
Master\u0027s Degree
22 satisfied customers
I have some data in an Excel spreadsheet that I need to
I have some data in an Excel spreadsheet that I need to graph. The data in the spreadsheet is a disk storage compression analysis that lists a set of volumes in Gigabytes. The next column shows how mu… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,217 satisfied customers
I need help with an excel formula. My first column has the
I need help with an excel formula. My first column has the "payout chart" showing 75,70,68,65,60,55,50,45,40,35,30,25,20,15,10,5,4,3,2 to be paid out to the players from 1st place through 19th place. … read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I have some time series data in excel. i wanted to produce
I have some time series data in excel. i wanted to produce a graph with the values on the y axis and the time on the x axis, and a straight line through the graph which shows the average through time.… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
Excel/Google Sheets question. I have a sheet of data. For each
Excel/Google Sheets question. I have a sheet of data. For each row, I am assigning a categorization. i.e. Row 1 is Category A; Row 2 is Category B; Row 3 is Category A, etc. On a different tab of the … read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I need to copy my spreadsheet and pie chart from excel into
I need to copy my spreadsheet and pie chart from excel into powerpoint and then within powerpoint edit the spreadsheet so that the changes also show up in my pie chart.… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
I have a very large spreadsheet (50,000+lines) and I need to
I have a very large spreadsheet (50,000+lines) and I need to pull the minimum value for a series of cells as follows. The layout of the spreadsheet lists a finished good on line 1 followed by the comp… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have recently exported data from my old website, which is
I have recently exported data from my old website, which is now discontinued. The data was in a MSSQL database but is now in Excel spreadsheets. i expected the data to be structured in such a way that… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need some help creating a stacked bar chart in excel, need
I need some help creating a stacked bar chart in excel, need about 4 charts total...at this point want to pay for service not instruction. Can someone do these charts… read more
cpugeek
cpugeek
IT Manager
Master's Degree
108 satisfied customers
How can I make interactive graphs? For example I wish to hit
How can I make interactive graphs? For example I wish to hit a play/start button which then shows a line graph appear along a time scale showing the changing pattern by time of day. thanks… read more
NY Eng
NY Eng
Control Systems Engineer
Bachelor\u0027s Degree
19 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x