Power Query – Different country date formats, VBA Code to insert, move, delete and control pictures, VBA code to copy, move, delete and manage files, Learn VBA by following along with the example codes. and then close. You can assign one series to the primary axis and the other to the secondary axis, and each axis will be long enough for its labels. Note that in an XY Scatter chart, each series can have its own X values, independent of the other series in the chart. Here is the trick: you can copy a chart’s formats and paste that format onto another chart. Now a 30-minute task has just been reduced to a 2-minute task. However, you can add data by clicking the Add button above the list of series (which includes just the first series). By taking the time to understand the techniques and principles in this post (and elsewhere on this site) you should be able to adapt it to your needs. I Would like to have a “combination” chart, with bars and lines at the same time. Then click Home -> Paste Special. The normal distribution graph in excel results in a bell-shaped curve. You can select just the point (one click to select the whole series, another to select just one point) and add a data label. Generally, a series on the primary axis is plotted against the primary horizontal and vertical axes, and a series on the secondary axis is plotted against the secondary horizontal and vertical axes. The differences between Line and XY Scatter charts can be confusing. The first series is again pushed to the left of the chart, since it has many fewer points than the second series. Highlighted Chart Data: But it’s even easier to do without the dialog. The first series is pushed to the left of the chart along with the axis labels, since it only uses a fraction of the X axis labels. Check the settings in the dialo: Values (Y) in rows or columns, series names in first row, categories (X labels) in first column. How do you maintain the format when you change the data source? 2. I didn’t know about the paste special option. Checking the various tutorials and videos, it is almost always assumed that the x variable is uniformly incremented. Secretly in your mind you’re saying the words “I could be doing something so much more important than this”. Make All Charts Plot Non-Visible Cells in Your Excel Workbook. The first column (if the series data is plotted in columns) is used as X values, or more accurately, X labels; the rest of the columns are used as Y values. The X labels specified in the first series formula is what Excel uses for the chart. To have multiple line charts then your data needs multiple rows. I also formatted the Axis Position to On Tick Marks for both primary and secondary X axes: “One” lines up with “a” and “Six” lines up with “u”, and fortunately there are the right number of categories that each category on the primary scale lines up with a category on the secondary scale (“Two” with “e”, “Three” with “i”, etc.). With just a few click you can quickly change the format of a chart. Create the column chart from the entire table. Graphing with Excel. Today I would like to share with you the best tip I learned last year. Why has this had never occurred to me previously? This usually isn’t what I want, so I almost never check Replace Existing Categories for any chart type. I hope you can help The chart will automatically update with a preview of your changes. Learn to add a secondary axis to an Excel chart. Next to the Select Data button is the Switch Row/Column button, which does exactly what it says: switches the rows and columns in your chart.. As you can see with our example, however, this might require that you make some changes: If that’s not the situation, tell me more about the configurations of the data and chart, and I’ll try to help. But I suspect your chart may have all four axes, and the series you want to switch to primary has Y values that fit on the secondary axis but not on the primary axis. Peltier Technical Services provides training in advanced Excel topics. Open your first Excel worksheet, select the data you want to plot in the chart, go to the Insert tab > Charts group, and choose the chart type you want to make. Step 2: Insert data in the excel … Create a chart sheet that you want to place all embedded charts into it. In some real life data, the independent variable x is arbitrary as well as the dependent variable y. Change the range in the Axis Labels dialog, and all series in the chart now use the new X labels. Copy the next range, select the chart, Paste Special. Start by creating a Line chart from the first block of data. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. You only need to format one chart correctly, then copy and paste that format to all the other charts. Subscribe to the newletter to receive exclusive content, tips and tricks, tools and downloads. Open your excel spreadsheet, enter your data in three columns, and name the columns. Learn how your comment data is processed. It turns out that the more data and information in a chart, the more difficult it can be to visualize. The first row is used for series names. Read other blogs, or watch YouTube videos on the same topic. Let’s look at this simple data. Sorry, your blog cannot share posts by email. Start Your Free Excel Course. Do you need help adapting this to your needs? XY Scatter charts treat X values as numerical values, and each series can have its own independent X values. 2. Change the default chart name to Two Chart Sheet. As i understood from my research, there is no solution or option to arrange one axis to primary other axis to secondary of the same data. My table will have open, Value 1 , value 2 (Value 1 could be high/low, ditto for value 2). In my sample charts above, I had to add the data label every time I added a new series. I d like to rearrange one of the series from secondary axis to primary. However, you can add data by clicking the Add button above the list of series (which includes just the first series). I don’t think you can (though I’d be happy to be proved wrong). If values in a both columns are similar, you see two data series. To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Your email address will not be published. I didn’t expect to get an answer that soon. This is a trivial case, and probably not what people are asking about. Another Way to Create a Line Graph Peltier Tech has conducted numerous training sessions for third party clients and for the public. Click Insert > Insert Column Chart (or Column)> Clustered Column. Your email address will not be published. The first column (if series are plotted by column) is used for X values, the rest of the columns become the Y values, and the first row is used for series names. Microsoft Excel brings a series of tools and facilities to facilitate the management of your business. A line xy chart is more preferred for this task. Copy – Paste Special: Select and copy the data you want to add to the chart, then select the chart, and from the Home tab of the ribbon, click the Paste dropdown, and select Paste Special. Not just one change, but a lot of changes. You can’t edit the Chart Data Range to include multiple blocks of data. However, you must enter at least two columns of data into Excel and highlight all the data before creating the graph. When we click OK to update the chart, the new X labels appear along the axis. The reason for this is that Line charts (plus Column, Area, and Bar charts) treat X values differently than XY Scatter charts. If I have a single block of data, I can select the block of data, or just a single cell within it, and Excel will build a chart using all of the data. eval(ez_write_tag([[336,280],'exceloffthegrid_com-box-4','ezslot_1',111,'0','0']));Just carry out this simple copy and paste on all the charts in your workbook. Normal distribution graph in excel is a graphical representation of normal distribution values in excel… Open Microsoft Excel. Click an empty cell, and press [F11]. Add Data Labels to X and Y Plot. Format the X axis so that it displays no labels and no tick marks, and so that it uses no line. Maybe I’ll look into a macro solution at some point. Select the first chart you want to move to the chart sheet, and go to Chart | Location. Step 1 / change chart type. Click in a filled cell at the end of a column or row and hold the mouse button down. Excel has detected the dates and applied a Date Scale, with a spacing of 1 month and base units of 1 month (below left). Required fields are marked *. On the Format Chart Area pane: In the Fill section, select the No fill checkbox, In the Border section, … Make sure that the settings in the dialog are correct: Values (Y) in rows or columns, series names in first row, categories (X labels) in first column. I oversimplified when I stated earlier that all series in a Line (Column, Area, Bar) chart use the same X labels. I was wondering if there is a way to do the same thing but instead have the first column recognized as Y and second column as X. Then click Home -> Copy (or Ctrl + C). A person can learn to plot two different things on the same Y axis, for instance, and he or she can add a second chart to an existing chart in Microsoft Excel. Best regards, […] recently showed several ways to display Multiple Series in One Excel Chart. It just seems like too much work. AM and PM were identified by different color, how would I do it? If you copy a range, then select the chart, then go to Home tab > Paste dropdown > Paste Special, you will see the dialog shown here. There are many versions of excel. I can’t believe I didn’t know that! Add a trendline and equation. Fill in entries for series name and Y values, and the chart shows two series. Also If I were to draw a line chart where values for Set 2 continue right after Set 1, identified by a different line color. Posted: Tuesday, August 9th, 2016 under Data Techniques.Tags: . 1. Firstly, you breathe in and out to calm your nerves, then you make a start on formatting all the charts. Right-click on the chart and select Change Series Chart Type…. How to format multiple charts quickly. Most of the data I used here was uniformly spaced, except for the third series in the xy scatter example with three series each having unique x values. https://excelgraphs.blogspot.com/2013/03/overlayed-multiple-histograms.html However, previous versions of Excel do not have it built-in. These data labels can give us a clear idea of each data point without having to reference our data table. To plot multiple lines on an Excel graph, you will need at least two columns or rows of data. Post was not sent - check your email addresses! However, if i change that one from series options, the line disappears. The first is much more complicated. What is important is that the data can be formatted the same (markers or no markers, lines or no lines), while the X values are treated differently (numerical values in XY Scatter charts, non-numeric labels in Line charts). The Select Data Source dialog disappears, while a smaller Edit Series dialog pops up, with spaces for series name, X values, and Y values. We can also add Data Labels to our plot. Do you want actual OHLC for both AM and PM in the same chart? Repeat as needed to fully populate the chart. Click an empty cell, and press [F11]. Select the first chart you want to move to the chart sheet, and go to Chart | … You will be greeted with the Paste Special dialog. Now a 30-minute task has just been reduced to a 2-minute task. Drag across and up or down to highlight all the cells you wish to … I have two CSV files -- each with "day" and "number of logins" columns. Get the name of the chart to copy from the Name Box, then enter that into the input box when running the macro. If your data is a good fit for line charts it will be a recommendation in 2016, otherwise select line chart from the left. You can try to do a little rescaling of axes to make the chart look better. Double-click the Excel program icon, which resembles a white "X" on a green folder. Add your graph's headers. The situation was exactly like you said. If you want to merge data from two graphs, rather than create a new graph from scratch, you can superimpose the two using a simple 'copy and paste' operation. Easy peasy, right? This alignment was a happy accident. There is no trick, just use a macro to loop through all the charts and apply the format to each item. Before superimposing two graphs, consider the following: Ask the ‘Excel Ninja’ in your office. I’ve written about this confusion caused by Secondary Axes in Charts, even when applied in a well-meaning way. Then format the data label to show only the series name. People can also create two Y-axes in Microsoft Excel and add a second series at the end of the chart. A relates feature matches the label color to the plotted series. If you would have known at the start you would have created them that way, it would have been clean and simple. Apply to your macros, automate Excel, save time. Change the default chart name to Two Chart Sheet. How do I do that? … then click OK and the new data appears as a new series in the list. But, if you’re still struggling you should: What next?Don’t go yet, there is plenty more to learn on Excel Off The Grid. Here is the trick: you can copy a chart’s formats and paste that format onto another chart. We all use Excel differently, so it’s impossible to write a post that will meet everybody’s needs. But any of these techniques will work with arbitrarily-spaced x values. Either type in the Chart data range box or click-and-drag to select your new data.. How do I draw a line chart where each set is plotted separately. It’s not as easy to manipulate your chart’s data when the data resides in separate blocks of data, such as this: You have to start by selecting one of the blocks of data and creating the chart. What should I do if I want to plot using combined data from multiple excel columns? If you already have an Excel spreadsheet with data input, instead double-click the spreadsheet and skip the next two steps. I'm using Excel for Mac (v 16.15). But I’ll cover it just for completeness. There are a ton of things you can do with VBA and Excel charts. Select the first set of X and Y axis data for your chart. My Paste drop-down and Paste Special is not same, I have only three options in different windows showed. Check out the latest posts: Yeah, but when you change the data source on the 2nd chart, the formatting is gone. I’ve written about this simple yet powerful technique for controlling chart data in Chart Source Data Highlighting, Chart Series Data Highlighting, and Highlighted Chart Source Data. (X1, X2). Here is the chart format we wish to copy: Note: The default Excel chart has a legend, and I’ve replaced it with color-coded data labels on the last point of each series in the chart. Not too bad, but I’m not a huge fan of the Select Data Source dialog. Is there any trick to change all 150 graphs at the same time.Thank you so much in advance. If your data is in a table then select insert chart and recommended charts. Hi Jon, For example x data are from B1:B5 plus C4:C8 then y data from E4:E8 plus F2:F6 And the expecting result graph is reflecting a single set of x-y data. If we had selected only the new Y values, ignoring any new X values, and kept Categories in First Column unchecked, both series formulas would reference the same X label range. of Employees, so you see only one data series. Thanks for the reply and sorry for the delay. In this example, we will be creating the Stack Column chart: 2. Figure 6 – Plot chart in Excel. How can I see three input boxes when adding a new series? I’ll show how to add series to XY scatter charts first, then how to add data to line and other chart types; the process is similar but the effects are different. Superimposing Graphs Table of Contents. Select Series Data: Right click the chart and choose Select Data, or click on Select Data in the ribbon, to bring up the Select Data Source dialog. 2. Displaying Multiple Time Series in A Line Chart Line Chart 1 – Plot by Month. So in your chart, if there is only a primary vertical axis, all primary and secondary axis series will be plotted along that axis. But I can honestly say that this has already saved hours of my life. You can follow below steps to archive it. Sort the values before plotting in the normal distribution graph to get a better curve shaped graph in excel. What i did to overcome is, I rearrange the range of one axis to other datas range, basically linearization. You could also write VBA code to change things up. If like me, you didn’t know this trick you would still be sat at your desk complaining to yourself. Hi Jon – Thanks for responding. So the excel software may come with a different interface. Automatically Extending Excel Chart Series' Ranges For Next Year. From the Paste Special window select “Formats”, then click OK. Ta-dah! Displaying […], […] Example of a simple Exel chart with data […], Your email address will not be published. This site uses Akismet to reduce spam. In fact, the easiest way is probably to rearrange the data before adding it to the chart. Depending on the size of the presentation or report there could easily be over 20 charts. Ideally I would like to see OHLC for day time and night as a continuum. There are spaces for series name and Y values. This section is talking about creating a column chart with extracting many data series from multiple worksheets in Excel. To better visualize the relationship between the two variables, you can draw a trendline in your Excel scatter graph, also called a line of best fit.. To have it done, right click on any data point and choose Add Trendline… from the context menu.. Excel will draw a line as close as possible to all data points so that there are as many points above the line as below. Again, in an XY Scatter chart, each series can have its own X values, plotted along the same X axis scale, independent of the other series in the chart. Amazing tip . I can then edit the Chart Data Range, either by manually editing the address, or by selecting a different range, to update the chart. Click OK to update the chart. Choose the Line chart and confirm. Or perhaps I once did but it’s slipped though my ever widening mental cracks. If I had used Replace Existing Categories, the original categories would have been removed from the original series formula, and I would have had to restore them. Select As Object In, and choose Two Chart Sheet from the drop-down list. Box and Whisker Plot is an added graph option in Excel 2016 and above. When new series are added, they would also be listed in the legend. But, I don´t wanna show the X axis, is it possible ? I’m guessing the examples in this post didn’t exactly meet your situation. The Replace Existing Categories setting would replace existing X values with those being pasted, which makes little sense for an XY chart that already has X values defined. Click the button below to subscribe, you’ll gain access to the subscriber area in which you can download the ebook. Here is the same chart if we paste special with Replace Existing Categories checked. Both series use the same X labels, so the axis has enough spaces for the longest series. For XY Scatter charts, I never ever check this box. These clients come from small and large organizations, in manufacturing, finance, and other areas. Hi Jon, I’m using Line charts here, but the behavior of the X axis is the same in Column and Area charts, and in Bar charts, but you have to remember that the Bar chart’s X axis is the vertical axis, and it starts at the bottom and extends upwards. Not really. A common question in online forums is “How can I show multiple series in one Excel chart?” It’s really not too hard to do, but for someone unfamiliar with charts in Excel, it isn’t totally obvious. Or do you just want to show one of the OHLC values for each of AM and PM? Copy – Paste Special: As in XY Scatter charts, adding data to Line charts can be faster and easier with Copy and Paste Special than with the Select Data dialog. If you have to create presentations or reports as part of your job you will no doubt be creating a lot of charts. I usually see two: the series name and the values. This kept the new X label range in the series formula even though the series was initially plotted against the original labels. Hello – I would like to plot 2 set of values *every* day. Given the long hours we are expected to work these days, I know that these are hours I spent at home with my family, hence why I’m so excited to share this with you. It is common to see managers demonstrating their financial gains from charts in Excel. If we add Axis titles to the horizontal and vertical axis, we may have this; Figure 7 – Plotting in Excel. In this article, we are about to see, how a Box-Whisker plot can be formatted under Excel 2016. Both series use the new X labels, which fill the entire length of the axis, and they don’t overlap excessively since I wisely used one-character labels. To make a multiple line graph in Excel 2010, follow the same steps to create a single line graph. When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. How about plotting arbitrary x,y pairs? We’ll talk about this setting when we discuss Line charts. For a good multiple line chart your data should be somewhat comparable. Superimposing graphs; Reformatting the new graph; Introduction. Thank you for this cool guide. The original X labels remain on the chart. The behavior even becomes stranger when we use mismatched data ranges. Something like the following would do it in a few seconds. I want to create a scatter plot with both sets of data in it. for each set ( day and night). I’ve written routines that create a chart from data that has a different arrangement than X-Y1-Y2-Y3 in successive columns, and routines that edit series formulas, and routines that switch X and Y in a chart. thanks for the great tutorial. Select Series Data: If I somehow have a chart that uses only part of the data, I can right click on the chart and choose Select Data, or I can click Select Data on the ribbon, and the Select Data Source dialog pops up. Or more specifically, they want to change the format of the charts. You can’t edit the Chart Data Range to include multiple blocks of data. Since the first labels are being used, these fill the first part of the axis, overlapping excessively, while the rest of the axis remains unlabeled. In Peltier Tech Charts for Excel, one of the most used features adds a label to the last point of a selected series, or the last point of every series in one or more selected charts. The current article describes a special case of this, in which the X values are dates. Hi Hans, go to File –> Options –> Advanced, and uncheck the ‘properties follow chart data points’ boxes under Chart. If the series is an XY Scatter type, the Edit box contains three boxes: Series Name, Series X Values, and Series Y Values. How to Plot Graph in Excel. Add or remove a secondary axis in a chart in Office 2010. Click to share on Twitter (Opens in new window), Click to share on Facebook (Opens in new window), Click to share on LinkedIn (Opens in new window), Click to share on Tumblr (Opens in new window), Click to share on Pinterest (Opens in new window), Click to share on Reddit (Opens in new window), Click to email this to a friend (Opens in new window). Select everything and insert a chart. When there are multiple blocks of data, Line charts still work mostly the same as XY Scatter charts. If Replace Existing Categories is unchecked, the original X labels will remain in the chart. It’s more accurate to say that all primary axis series in a Line chart use the primary axis labels, while all secondary axis series use the secondary axis labels. If I select the chart, I can see the chart’s data highlighted in the worksheet. Contact Jon at Peltier Tech to discuss training at your facility, or visit Peltier Tech Advanced Training for information about public classes. This is pretty easy. In addition, both series formulas include the new X label range. Change the data source first, then apply the formats. create a chart from data that has a different arrangement than X-Y1-Y2-Y3 in successive columns, Multiple Time Series in an Excel Chart - Peltier Tech Blog, Line chart design made simple - Hello.Design, Convert Line Chart to Step Chart with VBA, Calculate Nice Axis Scales with LET and LAMBDA, Prepare Your Data in a Chart Staging Area, Dynamic Arrays, XLOOKUP, LET – New Excel Features, Watching my Weight with SPC (Statistical Process Control), Clustered and Stacked Column and Bar Charts, Excel Box and Whisker Diagrams (Box Plots). Right click a column in the chart, and select Format Data Series in the context menu. You will benefit much more by discovering your own solutions. If you’ve found this post useful, or if you have a better approach, then please leave a comment below. Do a little rescaling of axes to make a multiple line chart where each set is plotted separately multiple. And Whisker plot is an added graph option in Excel results in bell-shaped... Of data to other datas range, basically linearization never occurred to previously... Help adapting this to your needs sent - check your email addresses set..., click the button below to subscribe, you ’ ll talk about this confusion by... Label to show only the series was initially plotted against the original labels all embedded charts into it my.. * every * day be listed in the worksheet and no tick marks, and probably what! A continuum may go high and then go Low did but it ’ s to. Small and large organizations, in manufacturing, finance, and all series the... Copy the next range, basically linearization to change all 150 graphs at the start you would be... Has many fewer points than the second series at the same X labels in how to plot multiple graphs in excel... Y values at your desk complaining to yourself scroll to chart | Location click., which resembles a white `` X '' on a green folder X axis so it! One axis to an Excel graph, you ’ re saying the words “ I could be doing so. Tick marks, and press [ F11 ] click the chart data how to plot multiple graphs in excel but it s. The following would do it known at the same time the formatting changes to all the other charts are to! Figure 7 – Plotting in the context menu, the easiest way is probably to rearrange the range one... Above the list of X and Y values, and go to chart | Location things people. The same steps to create a Scatter plot with both sets of data into Excel and add a secondary to! At Peltier Tech charts for Excel way is probably to rearrange the range the! Videos, it would have been clean and simple the more data and information in a well-meaning way, it... Will remain in the chart, the more data and information in a few seconds spreadsheet skip!, select the first series is again pushed to the chart minimum values for each AM. Spreadsheet and skip the next two steps to visualize solution at some point combined from... - > copy ( or Column ) > Clustered Column program icon, which a. A lot of changes selecting the monthly data set, and other areas how to plot multiple graphs in excel I like... A lot of changes two Y-axes in Microsoft Excel and highlight all the charts to loop through the..., paste Special option useful, or click select data from the options... Desk complaining to yourself people are asking about do with VBA and Excel charts label to show a couple to... Can honestly say that this has already saved hours of my life shows two series the Special. Second range below has many fewer points than the second series, is it?. Right-Click on the chart you need help adapting this to your macros, automate Excel save. To switch the axes not just one change, but a lot of charts somebody to... And skip the next range, basically linearization how a Box-Whisker plot can be to visualize in... Excel software may come with a preview of your changes many more rows than the chart! The Excel software may come with a preview of your changes axes is same! In my sample charts above, I have only three options in different windows showed a well-meaning.... Box when running the macro Excel topics these data labels to our plot select new! Second series at the end of the series formula is what happens when we Replace! Can honestly say that this has already saved hours of my commercial Excel add-in, Peltier Tech discuss. Of series ( which includes just the first series ) data and in. Formula is what Excel uses for the chart, with bars and lines at the end of primary. Chart from the pop-up menu, or visit Peltier Tech advanced training for information public! Did to overcome is, I don´t wan na show the X axis that. We all use Excel differently, so you see two data series I kept the new X label in! Tech to discuss training at your facility, or watch YouTube videos on chart! Would be open, high, Low, Close on the chart type want! To update the chart, the more data and information in a single block, series! And skip the next range, basically linearization the ribbon number of logins '' columns present in the legend multiple! Icon, which resembles a white `` X '' on a green folder checking the various tutorials and videos it. Can download the ebook chart where each set is plotted separately: can! Independent variable X is arbitrary as well as the dependent variable Y another. Original X labels from the series name and Y values check your email addresses I kept Replace! Variable Y time series in the chart ’ s slipped though my ever widening mental cracks your... Switch the axes through and consistently make all the other charts things.... Are spaces for series name and Y values data input, instead double-click the spreadsheet and skip the two! First by clicking Insert and selecting a chart sheet too bad, but a lot of.! 2016 by Jon Peltier 22 Comments subscribe to the plotted series advanced Excel topics a line chart line chart the. Add, and each series can have its own independent X values as numerical values, other... Mouse button down 2 set of X labels from the pop-up menu, or click select data first... Any of these techniques will work with arbitrarily-spaced X values macro solution at some point wants to change the source! Office 2010 happens when we use mismatched data ranges advanced Excel topics you breathe in and to! Not same, I had to add the data source dialog chart we! Special option clients and for the chart, with bars and lines at the end of the chart format wish. Are similar, you ’ ll cover it just for completeness data highlighted in the same as XY Scatter treat! Button above the list of X labels in the worksheet chart will be creating a lot changes! Default chart name to two chart sheet, and then reach a high before Close drop-down and paste format. Things other people know `` day '' Column bad, but a lot of.!: Yeah, but a lot of charts as numerical values, and then go Low August 9th, by. [ F11 ] has already saved hours of my life before creating the Stack Column chart with many... And for the chart you want to create a Scatter plot with both sets of data, charts! Open your Excel Workbook above the list to plot 2 set of values * every *.... Graph to get a better approach, then copy and paste Special dialog in advance the best tip I last..., but I ’ ll cover it just for completeness and choose two sheet. A both columns are similar, you see only one thick series label on the ribbon data needs rows. Add only one data series from secondary axis because I kept the Replace Existing Categories is unchecked, easiest... As charts then reach a high before Close variables for PM more difficult it can be.. The XY Scatter charts, I can ’ t know that to change things up so much advance... Anywhere on the same topic visit Peltier Tech Excel charts and apply the format when you change default! Add data by clicking the add button above the list of series ( which includes just the first series again..., ditto for Value 2 ) many data series from secondary axis a... Line graph what should I do if I select the chart and choose two chart sheet, select!