Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 26th 14, 09:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 90
Default Make Y-axis values correspond to x- axis value

(x) (y)
Group Minutes
-2 1.79
-1 7.61
0 26.45
1 28.9
2 17.18
3 27.8
4 26.1
5 26.7
6 25.8
7 21.8
8 17.4
9 0
10 33.69
11 0
12 0
13 0
14 14.8
15 0
16 0
17 17.18
18 0
19 0
20 20.48
I want to make a column graph(or bar), with the "Group" numbers being on the x-axis, and the "Minutes" being the y-axis value, so that "-2" is an x-axis value, and the above it is the bar representing 1.79, then the next value on the x-axis will be "-1", and above it will be a bar representing 7.61, and so on. It seems simple enough, but i am unable to accomplish this. What must I do?

Thanks,

Tonso

  #2   Report Post  
Old March 27th 14, 08:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2014
Posts: 1
Default Make Y-axis values correspond to x- axis value

Hi Tonso,

Am Mittwoch, 26. März 2014 22:10:44 UTC+1 schrieb Tonso:

I want to make a column graph(or bar), with the "Group" numbers being on the x-axis, and the "Minutes" being the y-axis value, so that "-2" is an x-axis value, and the above it is the bar representing 1.79, then the next value on the x-axis will be "-1", and above it will be a bar representing 7.61, and so on. It seems simple enough, but i am unable to accomplish this. What must I do?


select your Chart = Chart Tools = Select Data = Horizontal Axis Labels = Edit and Change the Axis Label Range to your expected range.
You can look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for the workbook "Chart_T"

Regards
Claus



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make chart with both horizontal-x axis vertical-y axis CEmery Charts and Charting in Excel 1 December 19th 07 07:11 PM
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017