Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2017, 06:50 PM
hcb hcb is offline Help with a "simple" chart, please Windows 7 64bit Help with a "simple" chart, please Office 2010 32bit
Novice
Help with a "simple" chart, please
 
Join Date: Mar 2017
Posts: 4
hcb is on a distinguished road
Default Help with a "simple" chart, please

Hello, All. I thought this would be something easily done but I'm having trouble getting a chart to work. I've used Excel lightly for 20 years but I am no expert and I have never done a chart before. I don't even know what words to use to try to search for a relevant answer, so I'm posting this.



What I have is historical market data regarding the sales of goats. The sales figures are broken into three weight bands (ranges). The data has the date the sale occurred, the weight range, and the average price (I created the weight range as a single column and the average price). At each sale there may be only animals in in one weight range or in all three weight ranges. What I want in my chart is a line that goes from the beginning of the data (back in 2002) through the present for each of the three weight ranges and which represent the average price for that weight range on that sale date.

To use real data from the attached file: line #2 has a date of 4/16/2002, weight range of 70-100, and an average price of $96.50. Also, on 4/16/2002, there is a weight range of 100-140 with an average of $73.00. I'd like that to be on the chart as one line for 70-100 and another line for 100-140. Notice that the next sale date, line #4, there is only one weight range represented in the sale data. This is simply the nature of the market and shows that all animals sold in this sale were in the 70-100 range.

Anyway, I appreciate your time and any help you can give me. I'm guessing this is a really basic question for someone who's done charts for a while, but I'm so inexperienced, like I said, I don't even know what search terms to use to find relevant answers.

Thank you.

--HC
Reply With Quote
  #2  
Old 03-11-2017, 09:56 PM
hcb hcb is offline Help with a "simple" chart, please Windows 7 64bit Help with a "simple" chart, please Office 2010 32bit
Novice
Help with a "simple" chart, please
 
Join Date: Mar 2017
Posts: 4
hcb is on a distinguished road
Default

I kept looking around ('cause I'm obsessive) and I found this website:

http://www.exceltactics.com/building...custom-x-axis/

The example that guy gives was close enough to what I wanted that I was able to get done what I needed to get done. Hopefully that will help someone else.

Thank you.

--HC
Reply With Quote
  #3  
Old 03-12-2017, 01:48 AM
xor xor is offline Help with a "simple" chart, please Windows 10 Help with a "simple" chart, please Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I am not sure if the attached is what you want, but please take a look.
Attached Files
File Type: xlsx San Angelo.xlsx (167.9 KB, 13 views)
Reply With Quote
  #4  
Old 03-12-2017, 08:19 PM
hcb hcb is offline Help with a "simple" chart, please Windows 7 64bit Help with a "simple" chart, please Office 2010 32bit
Novice
Help with a "simple" chart, please
 
Join Date: Mar 2017
Posts: 4
hcb is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
I am not sure if the attached is what you want, but please take a look.
Thank you for the reply. That is exactly what I was trying to accomplish.

I started over, based on what I'd learned from the linked site I posted and what I saw you achieved. I was able to get basically the same thing by hitting the "Hidden and Empty Cells" button from the Select Data window.

What I've not found is how to select the colors used.

Thanks for your time.

--HC
Reply With Quote
  #5  
Old 03-13-2017, 12:04 AM
xor xor is offline Help with a "simple" chart, please Windows 10 Help with a "simple" chart, please Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Color:

Right click the green line (for example). Format Data Series. Line Color, and choose color.
Similarly for other lines.

Right click somewhere in the light blue area. Format Plot Area. Fill, solid fill, choose color.
Reply With Quote
  #6  
Old 03-14-2017, 03:28 AM
hcb hcb is offline Help with a "simple" chart, please Windows 7 64bit Help with a "simple" chart, please Office 2010 32bit
Novice
Help with a "simple" chart, please
 
Join Date: Mar 2017
Posts: 4
hcb is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Color:

Right click the green line (for example). Format Data Series. Line Color, and choose color.
Similarly for other lines.

Right click somewhere in the light blue area. Format Plot Area. Fill, solid fill, choose color.
Thank you again. I got caught up in the dialogs/windows and forgot the most basic of principles with Windows: when in doubt, right click!

I appreciate your help.

--HC
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a "simple" chart, please simple inventory sheet "i think" moedope Excel 12 02-08-2017 08:11 AM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon CensorTilSin Outlook 1 12-11-2013 12:05 PM
Chart needs #N/A, SLOPE function needs "q" ue418 Excel 0 10-16-2012 01:46 PM
Help with a "simple" chart, please How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft