Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2020, 05:01 PM
oscarlimerick oscarlimerick is offline I cant find my clustered column line template? Windows 8 I cant find my clustered column line template? Office 2013
Advanced Beginner
I cant find my clustered column line template?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default I cant find my clustered column line template?


I am trying to create a clustered column graph with an average line running horizontally through it, displaying the average value of the totals of column D. As my spreadsheet shows, I am able to create the date vs totals ok, but I can’t get the average line. In theory the average line (currently 68 as per cell H3), so there should be a horizontal line running through this graph at 68. I think to do this I need to insert a clustered column-line template, but I can’t find this option in the insert-recommended charts-all charts (see screen snapshot). I am using excel 2013 and as far as I know, I am supposed to have the clustered column-line template, but I can’t find it! Am I overlooking something here? Please advise. Many thanks
Attached Images
File Type: jpg insert chart display.jpg (136.7 KB, 13 views)
Attached Files
File Type: xlsx practise sheet.xlsx (16.2 KB, 8 views)
Reply With Quote
  #2  
Old 09-15-2020, 08:34 PM
Purfleet Purfleet is offline I cant find my clustered column line template? Windows 10 I cant find my clustered column line template? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Okay it might be cheating and i am sure there is a proper way of doing it, but....
Attached Images
File Type: jpg I cant find my clustered column line template_purfleet.JPG (67.5 KB, 12 views)
Attached Files
File Type: xlsx practise sheet)_Purfleet.xlsx (17.1 KB, 6 views)
Reply With Quote
  #3  
Old 09-16-2020, 07:19 AM
oscarlimerick oscarlimerick is offline I cant find my clustered column line template? Windows 8 I cant find my clustered column line template? Office 2013
Advanced Beginner
I cant find my clustered column line template?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

I don't know why it would be cheating, it does seem to work, but I need to create extra columns on the worksheet for average, and if I hide the column the graph won't work. What if i wanted to modify my graph slightly, and show a goal line along with the average. Lets say the goal was 100, how can I have the graph display a horizontal line across it at the totals 100 value, along with my average marker, the horizontal line at about 68? Thanks
Reply With Quote
  #4  
Old 09-16-2020, 01:32 PM
Purfleet Purfleet is offline I cant find my clustered column line template? Windows 10 I cant find my clustered column line template? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

I assumme there is an offical way of doing it, but i only know this way and while it works there are some limitations.

so a further cheat...

Put the data on sheet2, base your graph with a target on sheet 2 then just link the bits you want to show on sheet1

see attached

let me know if its what you were after
Attached Files
File Type: xlsx practise sheet)_Purfleet2.xlsx (18.8 KB, 5 views)
Reply With Quote
  #5  
Old 09-16-2020, 03:04 PM
oscarlimerick oscarlimerick is offline I cant find my clustered column line template? Windows 8 I cant find my clustered column line template? Office 2013
Advanced Beginner
I cant find my clustered column line template?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default Clustered column and line graph

Ok, well the graph you created is precisely what I wanted my graph to look like, but how did you select the cells on 2 different tabs to create this graph? If I select a4 to a15,b4-b15, e4-e15 on tab 1, and also select a1 to a13, b1-b13, and f1-f13 on tab 2, and then try and insert a graph, I am not given the option to create a clustered column and line graph, it only lets me make a clustered column graph,so maybe I am selecting the wrong cell ranges for my graph? Thanks
Reply With Quote
  #6  
Old 09-16-2020, 03:19 PM
oscarlimerick oscarlimerick is offline I cant find my clustered column line template? Windows 8 I cant find my clustered column line template? Office 2013
Advanced Beginner
I cant find my clustered column line template?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

I think I got it: If I right click on the graph and then click on select data, and then use the add function, I can add a range of cells to a new axis and give it a title. You certainly know your excel Purfleet, I hope you are getting paid for all this free advice.
Reply With Quote
  #7  
Old 09-16-2020, 08:17 PM
Purfleet Purfleet is offline I cant find my clustered column line template? Windows 10 I cant find my clustered column line template? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

thas one way, but if you want to cheat...



I just cut your data from sheet1 and pasted in sheet 2!


Glad it helped
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to check combinations of values in one column to find match from another column kong1802 Excel 1 06-15-2018 05:26 AM
I cant find my clustered column line template? Table column line moves joannechee2 Word Tables 7 03-17-2016 12:21 AM
VBA: Find a column by its date Officer_Bierschnitt Excel Programming 1 10-31-2015 02:06 PM
I cant find my clustered column line template? column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
I cant find my clustered column line template? Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums

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


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