| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Hybrid Mode
