View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
[email protected] claus_busch@t-online.de is offline
external usenet poster
 
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