Home

Excel chart select source data issues

%3CLINGO-SUB%20id%3D%22lingo-sub-861801%22%20slang%3D%22en-US%22%3EExcel%20chart%20select%20source%20data%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861801%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20used%20to%20have%20a%20dialog%20box%20for%20customizing%20data%20selection%20of%20a%20chart.%20You%20could%20specify%20the%20exact%20cell%20range%20of%20an%20axis%20to%20manipulate%20graphing%20data%20and%20it%20was%20fairly%20intuitive%20to%20use.%20If%20you%20had%20two%20series%20of%20data%20in%20adjacent%20columns%2C%20it%20was%20easy%20to%20set%20one%20%3CSPAN%3Eas%20the%20x%20or%20y%20axis%20and%20the%20other%20as%20the%20actual%20series%20being%20charted%20through%20the%20%22format%20axis%22%20option%20the%20right-click%20dropdown%20menu.%20The%20current%26nbsp%3B%20%22select%20data%20source%22%20dialog%20box%20does%20not%20appear%20to%20let%20you%20do%20this%2C%20and%20formatting%20axis%20through%20the%20side%20panel%20doesn't%20either.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20an%20example%20of%20something%20that%20used%20to%20be%20relatively%20easy%20to%20manipulate.%20Column%20A%20represents%20soil%20depth%2C%20%22z%22%2C%20Column%20B%20is%20a%20calculated%20soil%20pressure%20(delta)%20that%20varies%20with%20the%20vertical%20depth.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20762px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132421iEA127CF82B1D1F8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20troubles.JPG%22%20title%3D%22excel%20troubles.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eclose%20but%20no%20cigar%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPlotted%20correctly%2C%20you%20should%20be%20able%20to%20get%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20330px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132422iFD2598EB600EAAF1%2Fimage-dimensions%2F330x340%3Fv%3D1.0%22%20width%3D%22330%22%20height%3D%22340%22%20alt%3D%22excel%20troubles%204.JPG%22%20title%3D%22excel%20troubles%204.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20excel%20chart%20with%20the%20blue%20curve%20is%20close%20to%20what%20I%20want%20but%20should%20be%20transposed%2C%20with%20column%20A%20series%20along%20the%20y%20axis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20was%20only%20able%20to%20achieve%20the%20above%20chart%20by%20excluding%20Column%20A%20from%20the%20data%20series%20selection.%3C%2FSPAN%3E%20However%20what%20I%20actually%20need%20to%20chart%20is%20the%20transpose%20of%20this%3B%20instead%20of%20the%20x%20axis%20reading%20the%20row%20number%20I%20need%20it%20to%20read%20the%20corresponding%20depths%20from%20column%20A.%20When%20I%20try%20to%20add%20Column%20A%20I%20just%20get%20another%20series%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132420i0DBBC23B61D46B76%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20troubles%202.JPG%22%20title%3D%22excel%20troubles%202.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eadding%20the%20series%20that%20should%20be%20the%20%22y%22%20axis%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20as%20far%20as%20I'm%20able%20to%20get.%20Switching%20row%2Fcolumn%20does%20not%20address%20it%2C%20and%20I'm%20unable%20to%20get%20the%20axis%20to%20read%20the%20data%20from%20column%20A%20instead%20of%20jus%20the%20index%20row%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20to%20work%20in%20excel%20quite%20a%20bit%2C%20there%20was%20definitely%20an%20older%20version%20with%20a%20dialog%20box%20that%20allowed%20easy%20manipulation%20of%20data.%20You%20could%20select%20y%20and%20x%20axis%20data%20range%20for%20each%20data%20series.%20In%20the%20past%20I've%20done%20some%20impressive%20graphing%20and%20complex%20spreadsheets%20to%20calculate%20structural%20load%20paths%20with%20cell%20and%20matrix%20referencing%2C%20so%20I%20would%20not%20consider%20myself%20a%20novice%20-%20yet%20this%20simple%20thing%20has%20me%20in%20self%20doubt%2C%20feel%20like%20I%20don't%20even%20have%20the%20basic%20fundamentals%20down.%20What%20happened%20to%20the%20old%20dialog%20box%2C%20and%20how%20do%20I%20work%20around%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
dgarris
Occasional Visitor

Excel used to have a dialog box for customizing data selection of a chart. You could specify the exact cell range of an axis to manipulate graphing data and it was fairly intuitive to use. If you had two series of data in adjacent columns, it was easy to set one as the x or y axis and the other as the actual series being charted through the "format axis" option the right-click dropdown menu. The current  "select data source" dialog box does not appear to let you do this, and formatting axis through the side panel doesn't either.

 

Below is an example of something that used to be relatively easy to manipulate. Column A represents soil depth, "z", Column B is a calculated soil pressure (delta) that varies with the vertical depth.

 

excel troubles.JPGclose but no cigar

Plotted correctly, you should be able to get something like this:

excel troubles 4.JPG

The excel chart with the blue curve is close to what I want but should be transposed, with column A series along the y axis.

 

I was only able to achieve the above chart by excluding Column A from the data series selection. However what I actually need to chart is the transpose of this; instead of the x axis reading the row number I need it to read the corresponding depths from column A. When I try to add Column A I just get another series added.

 

excel troubles 2.JPGadding the series that should be the "y" axis

This is as far as I'm able to get. Switching row/column does not address it, and I'm unable to get the axis to read the data from column A instead of jus the index row number.

 

I used to work in excel quite a bit, there was definitely an older version with a dialog box that allowed easy manipulation of data. You could select y and x axis data range for each data series. In the past I've done some impressive graphing and complex spreadsheets to calculate structural load paths with cell and matrix referencing, so I would not consider myself a novice - yet this simple thing has me in self doubt, feel like I don't even have the basic fundamentals down. What happened to the old dialog box, and how do I work around this?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies