Xchart addseries This allocates an lv_chart_series_t structure which contains the chosen color and an array for the data points. The configuration Dec 6, 2022 · In this tutorial, we will show how you can add an additional series to an existing chart without recreating the chart. The problem is that the new line series over Represents a chart object in a workbook. The chart object is then inserted in the worksheet using its insert_chart () method. It allows you to compare multiple sets of data on the same chart, making it easier to spot trends, patterns, and outliers. The Time Series Chart includes the following features: Zoom or pan in and out via mouse wheel interaction. AspNet. What's reputation and how do I get it? Instead, you can save this post to reference later. Data series ¶ You can add any number of series to the charts by lv_chart_add_series(chart, color). The basic primitive to display data is a series. Sep 4, 2025 · A new series is initialized either through the series option structure, or after the chart is initialized, through Highcharts. This selects the data range of the chart and displays the Select Data Source dialog box. If your chart's categories are based on features, you can manually include multiple series in the chart by clicking Add series. Jul 18, 2016 · Learn how to create dynamic series labels in Excel for clearer, more readable charts. This article teaches the ins & outs of the SERIES formula, so you can add it to your Excel skills. At the right, click Setup. After creating a chart, you might need to add an additional data series to the chart. Understanding how to manage data series effectively can transform raw data into insightful visuals. The pie chart defies all rules of best practices regarding data visualization, but it’s just there to show off the concept. You can add predefined lines or bars to charts in several apps for Office. 6 Compare multiple series This Multi-Series Comparison Example illustrates how an assortment of data series can be integrated into a single chart for comparisons. In the following example we borrow the Color Brewer colours from Vincent and apply them to a scatter chart: To generate charts programmatically, XlsxWriter library has a Chart class. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Follow the steps below to dynamically add or remove a series. The object can be accessed in a number of ways. Conclusion The calculated series feature in SSRS allows us to easily add trendlines to an existing graph. Add With Chart1 . If you want to add an additional series, you would create the new series and call that again to add it. But legends don’t just appear automatically—you’ll need to add them to your charts. So i have a textbox with a button . It is generally used for analytics purposes to get a close approximate idea from the chart. Oct 12, 2022 · This post is the ultimate guide for VBA for charts and graphs in Excel. To locate the chart name, click the chart and look at the Name Box to the right of the Insert Function box. Chart#addSeries. Add didnt help very much as Excel tries to automatically find the correct ranges for all series and adds them resulting in a completely messed up chart. Simply use the charting API addSeries to create multiple series. Series with an incompatible view are not displayed. Oct 12, 2019 · I am use pyqt5 to draw a simple chart and need to add custom axis, but when i add axis , the chart not show it, and when hovered signal emit, i need to show corresponding point , but it also not sh. Add (Source, Rowcol, SeriesLabels, CategoryLabels, Replace) expression A variable that represents a SeriesCollection object. Dec 8, 2022 · In this tutorial, we will demonstrate how you can add series lines in a chart in Excel. Helpers 程序集: System. In the majority of Excel charts the X axis is the category axis and each of the values is evenly spaced and sequential. Excel charts offer robust functionality for visual data representation, making it easier to identify trends and patterns. In this tutorial, we will explore how to add another data series to a chart in Excel, allowing you to compare and contrast multiple sets of data in a s Learn how to add a series in Google Sheets for faster management. Jan 11, 2024 · Adding a series to an Excel Chart is a simple process that can greatly enhance the visual representation of your data. 2. So now that we’ve created a chart and a bunch of series, what else can we do? The method you use depends on how your chart's categories are determined from its data. Then, edit the Name and Y values boxes to make any changes. Its object is obtained by calling add_chart () method of the Workbook class. Sep 12, 2023 · Replace Chart 4 in the code element ActiveSheet. this adds random data, but what i want is t XChart is a light-weight and convenient library for plotting data designed to go from data to chart in the least amount of time possible and to take the guess-work out of customizing the chart style. Aug 6, 2025 · Learn how to enhance your Excel charts by adding multiple data series for better comparisons and insights. Multiple series can be plotted Learn how to add a series to an Excel chart with this step-by-step guide. Aug 22, 2011 · Problem A report might contain multiple data series on a chart, which can have considerably varying scales but common category groups. The guide includes over 100 code snippets that you can use in your own code. Jul 10, 2016 · I want to addSeries in onclick event of a point, but I got an error that addSeries isn't a function of current this. I think t Jul 11, 2024 · Learn how to easily add a new data series to your Excel chart with our step-by-step guide, enhancing your data visualization and analysis effortlessly. from_series helper methods are also available on the HighchartsOptions class. Jul 15, 2024 · Learn how to effortlessly add another data series to your Excel chart with our step-by-step guide, enhancing your data visualization skills in just minutes! Mar 30, 2022 · expression. Upvoting indicates when questions and answers are useful. To edit a legend series, in the Legend entries (series) box, click the series you want to change. Aug 3, 2015 · This is my VBA code to create a scatter plot in Excel: Sub createmychart() Dim Chart1 As Chart Set Chart1 = Charts. In this tip we will take a look at how to solve this problem using Chart Areas. Sep 1, 2022 · Adding the area series and setting it's options We can add the area series as we did with the candlestick series by calling the addSeries (AreaSeries) method on the chart instance. Sep 24, 2019 · Data in an Excel chart is governed by the SERIES formula. Understanding Chart Series in Google Sheets Before we roll up our sleeves and get into the nitty-gritty, it's important to understand what a "series" in a chart actually means. Helpers. Series ser = new Series(seriesName); ser. The configuration Mar 17, 2015 · I want to add different line chart one at the time to my chart. Jan 12, 2013 · When the chart editor complains that you need to add a series, the problem is usually with the existing data. For example if you want to chart multiple lines on a line chart, or if you want to have multiple columns for each x-axis value on a column chart. Calling Delete forces re-calculation of Functions and repainting of the Chart. The container is dynamically inserted into the element given as the renderTo parameter in the Highcharts#chart constructor. How do I add it back? When creating a chart in Excel, you can add series to represent different sets of data within the same chart. Excel doesn't provide us the flexibility to May 29, 2024 · Add or Remove Series in Blazor Charts Component 29 May 2024 7 minutes to read The chart series can be dynamically added or removed by adding and removing a series to the ChartSeriesCollection. Excel 2013 Chart - Multiple Series on Pivot Chart Ask Question Asked 11 years, 4 months ago Modified 6 years, 8 months ago Dynamically adding and removing Series This tutorial will show how you can dynamically add and remove series to the chart. Insert the chart into a worksheet using worksheet_insert_chart(). Double-click the chart to open the chart editor. I have a bar chart with "two" columns of data at each X-axis point. If your chart is on the Aug 26, 2016 · I have nice working chart with stock typed graph. To add a new series dynamically, add a series object to the series collection of chart instance. Adding a Series to an Excel Chart. About The Trainer: This Microsoft Excel tutorial is presented by Richard Giles Walters. Remarks This class exposes all of the properties, methods and events of the Chart Windows control. However, if you add a series of data points to a Jul 11, 2025 · Prerequisite: Python | Plotting charts in excel sheet using openpyxl module | Set – 1 Openpyxl is a Python library using which one can perform multiple operations on excel files like reading, writing, arithmetic operations and plotting graphs. One to display the value inside the end of the bar, the other to display a % off a baseline number outside the bar. Switch rows & columns in a chart On your computer, open a spreadsheet in Google Sheets. You can create an instance for chart, by calling the ejChart constructor method with the string “instance” as parameter. The same . Oct 30, 2023 · This tutorial will demonstrate how to add series to graphs in Excel & Google Sheets. Jul 30, 2023 · This time we are going to edit the data range before clicking “Add series” so that the series we want to add will be available directly in the dropdown menu after clicking “Add series”. i am using <scr Feb 20, 2025 · Learn how to add and customize multiple data series in Google Sheets charts to create powerful, insightful visualizations that enhance data comparison and storytelling. XChart is a light-weight and convenient library for plotting data designed to go from data to chart in the least amount of time possible and to take the guess-work out of customizing the chart style. addSeries. In this tutorial, we’ll show how to add new series to an existing graph. Charts are composed of at least one series of one or more data points. By default, we can't directly plot a Trendline over a Stacked Column Chart. However, if you add a series of data points to a Jul 3, 2013 · You'll need to complete a few actions and gain 15 reputation points before being able to upvote. Activate with the chart name of your own worksheet. With clear instructions and helpful screenshots, you'll be adding series to your Excel charts like a pro in no time. The first series’s view defines the available series view groups the chart can display and specifies the chart’s diagram type. But you can go further and customize the legend to tweak its position, labels, fonts Aug 30, 2023 · In this lesson I am going to show you how to chart multiple series in Google Sheets, where you are charting data with multiple columns per row, or vice versa. Inorder to do this, I'm using the chart. For example, Series A, which is plotted, may be the result of adding Series B and Series C data points together, though neither of these series is plotted. addSeries function. Configure the chart with the other available functions shown below. When Q2 Sales data becomes available how do I add it to an existing chart using VBA? To do it in Excel, here is the answer: Often, engineers need to display two or more series of data on the same chart. At a certain point, I collect the temperature of certain images and group them into arrays (average, minimum and maximum temperatures) Chart. The library supports the following series types: Area Bar Baseline Candlestick Histogram Line To create a series, use the addSeries method from IChartApi. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. i input a code and load the series from my database. Then options for all series of a specific type are given in the plotOptions of that type, for example plotOptions. Net Chart Controls which gives us a way to take the data that we have and quickly create a chart such as a pie chart or a line chart and present the data with little to no effort on the system. A row or column of numbers in Excel that are plotted in a chart is called a data series. Adding series Adding a series to the chart is as simple as pushing a series object into chart's series list: Aug 25, 2024 · 文章浏览阅读4. chart = new Highcharts. The data in the series is stored in various Jul 22, 2024 · I hit a case where the arguments that I'd like to pass to addSeries won't jointly "fit" in any combination of the slots provided by the current signatures of addSeries for a CategoryChart. When you click the command button, Excel displays a menu with commands corresponding to locations for the data labels: None, Center, Left, Right, Above, and Below. Let's see how to Jul 3, 2013 · You'll need to complete a few actions and gain 15 reputation points before being able to upvote. In this video, we'll look at how to add and remove data series in a chart. Data for the method can be passed in different formats: it can be a simple array of data objects, a data set or a data view. Now, I want to add another field (series?) into the Quick Excel Chart VBA Examples The use of VBA in Microsoft Excel charting is a topic that would fill a large volume. The first series also should be added dynamically via data comming from a web The basic procedure for adding a chart to a worksheet is: Create the chart with workbook_add_chart(). The examples here are straightforward illustrations of easy techniques to create charts, add and remove series, and move and resize charts using VBA. Try… Mar 14, 2019 · @ mmikeinsantarosa You added your series via chart->addSeries(series);. Whether you Dec 9, 2021 · From this I am producing a column chart. Mar 26, 2016 · The Data Labels command on the Design tab’s Add Chart Element menu in Excel allows you to label data markers with values from your pivot table. Above that all that objects are heavy connected. X-Trace You can add any number of series to the charts by lv_chart_add_series(chart, color, axis). Aug 26, 2016 · How i should add and remove series from qchart? The main mess is that QChart some how store QAxis and QSeries, QSeries themselves refer to QAxis. You can plot one or more data series in a chart. SetSourceData Source:=Sheets("usd_download d May 23, 2018 · Creating the series first, and adding it to the Chart after all of the appends solved the problem Each append if the seires is already on the QChart triggers an update. Series Points Retrieving and modifying Points Once points have been added, you can retrieve their co-ordinates or change them. Customize the axes Edit the vertical axis How Series are Organized As the diagram above shows, Highcharts visualizations are configured within a Chart object, which has the . All data plotted on a chart comes from the series object. This comprehensive tutorial covers everything you need to know, from selecting the data to formatting the chart. Fires when a series is added to the chart after load time, using the addSeries method. ChartArea = "Default"; ser. lines, columns) as needed with an additional line for each new series. Sep 26, 2017 · Dynamically Label Excel Chart Series Lines instead of using legends which are slow to interpret. attachAxis () should be called after addSeries () Aug 16, 2013 · i have made a chart using highcharts, and i want to redraw my high chart, but this line of code is confusing me and not allowing me to add existing data. Each of the changing columns will be a new series added to the chart. add_series() seems to not recogni Nov 3, 2023 · In this tutorial, you will learn how to add series in Google Sheets. Table of Contents Series changes Series Markers Watermarks Plugin Typings Series changes Overview of Changes Unified series creation API using single addSeries function Better tree-shaking support Individual series types must now be imported separately (for ESM) Migration Steps Replace all Sep 1, 2022 · In this section, we will be customizing the visual styling of the candlestick series. So Then, make your changes. If your chart's categories are based on grouped values, you can create a multiseries chart by specifying Split by field. Jun 14, 2024 · We can add a chart in Excel with just one line of VBA code specifying a range with source data. x1, y1 and x2, y2 where x1 =! x2 I tried using the api but keep getting the err Sep 19, 2016 · Enter the . Series What is a series? A series is a set of data, for example a line graph or one set of columns. When I tried to add line typed series to this chartarea I got big red X. renderTo: 'graphicShow', type: 'spline', events: { load: requestData. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word. Automate repetitive entries and improve spreadsheet efficiency with our step-by-step guide. It displays data in your Windows Forms program as a bar graph or chart. How can I add Series to HighChart Graph when I click on one of his points? Essential Chart supports dynamically customizing all the properties with the instance of Chart in client-side. Chart Series A SeriesCollection object refers to a collection of all the Series objects in a chart. However, I've been unable to get results as the method chart. Jan 31, 2025 · Lightweight Charts™ Version: 5. Jul 6, 2016 · I must define the chart. Adding Series Line in an Excel Chart Let us suppose we have an Excel sheet with the following data: Step 1 To create the chart, select the data ? click Insert ? select Stacked Column Chart under the Chart section. WebPages v3. In this section, we’ll add a second plot to the […] Feb 19, 2020 · I cannot figure out a way to add series to a line chart such that each series has a different number of samples, i. Add one or more data series to the chart which refers to data in the workbook using chart_add_series(). options property where the chart’s configuration “lives”, represented as a HighchartsOptions instance. Click on the chart. For example, a chart type might require that the data is numbers, but in fact it is text strings such as 123_ (three digits and a space). For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. We will pass the options for the series as the second argument to addSeries () method instead of separately calling applyOptions () at a later stage. You add series one at a time (no need/support for adding a list of them) via QChart::addSeries(), and you can access all added series via QList<QAbstractSeries *> QChart::series() const showing that there are a list of Nov 2, 2018 · I have been trying to create a chart for some data I'm printing on Excel from Python using xlsxwriter. On the ribbon, click Chart Design and then click Select Data. Jan 9, 2019 · The best way to set the XlsxWriter chart range programmatically is to avoid the Sheet1!D1:D12 style range syntax and use the alternative list syntax shown in the . All series and point event handlers give a reference to the series object. Vba dynamically add series to chart in Excel For example, I already have a chart ("Chart1") of Sales data for Q1-2016. axis can have the following values: In conclusion, adding another data series to a chart in Excel can significantly enhance your data visualization and analysis capabilities, providing deeper insights and facilitating comparative analysis. ChartObjects("Chart 4"). This Chapter illustrates Chart Series, Data Labels & Chart Legend. Since we as data analysts spend some much time creating graphs, it is more valuable than ever to understand how to automate them. I am now looking at increasing the sophistication of the existing table/chart by: 1. Web. Jul 9, 2024 · A legend is a key component of most Excel charts. Name = Sep 28, 2023 · I am trying to code adding a new data series to a multi-series line chart in Google Sheets. As Introduction When creating charts in Excel, it is crucial to add series names to clearly label the data being represented. In such cases where this a big difference in scales, the data series with the lower scale can become obscured. An introduction to the creation of Excel files with charts using Pandas and XlsxWriter. Series collection. We would like to show you a description here but the site won’t allow us. Aug 2, 2024 · Learn how to add a new data series to existing Excel charts for enhanced data visualization. Creating a series When the chart is created, you can display data on it. 命名空间: System. Sep 4, 2025 · Options for all series in a chart are given in the plotOptions. Microsoft Excel 2013 charts are dynamic in that they automatically update when the current data changes. series object. add_series ( {})" to match the columns in the dataframe Can I loop through the columns and produce a new "chart1. Then we can add as many series (i. Series themselves are comprised of references to cell ranges. 2. Step 1: Render a series using ChartSeriesCollection class of the chart. The chart object has a series property that is a collection of all the chart's Dec 15, 2014 · If you click Yes, a new chart area is added to the chart that will contain the newly created calculated series. Free downloadable chart template included. A series, in this context, refers to a set of related data points plotted on the chart. Put the new series name into the code element "=""Sales""" to change the name of the first series in the chart object. My data is in columns and I want to run a script that inserts a new column and then edit the chart so tha There is one more way of creating multiple-series charts: the addSeries () method can add any number of series to a chart. To chart multiple series in Google Sheets, follow these steps: Insert a chart on the tab Jul 6, 2021 · I am trying to add more series to my line chart using pivot table. Outline: Quick Chart VBA Examples VBA Code to Add Chart Objects and Series Add a Chart Add a Series Too Many Series? Putting It Perspective - Time Series Chart Component Palette The Time Series component provides an efficient way to visualize data from a variety of different data sources as chart data. caution RequirementsAs a result, createChart returns an IChartApi object that allows you to interact with the created chart. In this tutorial, we will cover the importance of adding series names in Excel charts and provide a step-by-step guide o Sep 11, 2024 · Need to visualize more than one set of data on a single Excel graph or chart? This wikiHow article will show you the easiest ways to add new data to an existing bar or line graph, plus how to plot a second data set to compare two sets of similar linear data on a single graph. add_series ( {})" for each column? - and if "yes", any examples would be helpful. Web. (I copy-past message from link above): It is unlogical that I should QChart *chart->addSeries (CalibSeries); before QScatterSeries *CalibSeries;->attachAxis (axisX); Isn't it? And no information in Qt doc too I suggest add information to Qt doc. Create a XYChart instance via QuickChart, add a series of data to it, and either display it or save Apr 18, 2003 · I have just learned how to create Pivot Tables / Charts, and have the basics down. Aug 13, 2021 · Note All series that the chart displays should have compatible series views. Each Aug 4, 2016 · I deleted a series from a legend in my chart by selecting it and pressing Backspace. The data changes and a user can select which series to view. This allows for easy comparison and analysis of multiple data points. Tip: You can’t add a second X-axis, but you can add series sets. Mar 4, 2013 · I had a problem in adding series dynamically with highstock. Chart Elements – Chart Title, Chart Area, Plot Area & Chart Axes – are illustrated in Part 1. Nov 26, 2013 · Also, the use of Charts. These bar graphs can then be used in a variety of places or displayed directly in a Windows Forms program. This can save you a lot of time and also help you understand the outcome if any new data is added. Please see suggestion. series [i] because it say "Cannot set property 'name' of undefined" but i can't find a way in order to do this. The Chart control visualizes your data. Without series names, the chart can be confusing and difficult to interpret. Chart Value and Category Axes When working with charts it is important to understand how Excel differentiates between a chart axis that is used for series categories and a chart axis that is used for series values. If your chart is on the Feb 22, 2017 · I'm trying to create a group of chart series, add data to the series and then show a few of the series by making them visible. In this post we add series that represent additional trials of an ongoing clinical test for a Data labels make a chart easier to understand because they show details about a data series or its individual data points. Colours are configurable for almost all aspects of XlsxWriter charts. Whatever you do, leave the Chart Source Data box alone. Provides data points and series attributes for the chart. Learn about Chart Series support in Syncfusion Essential Studio® Windows Forms Chart control and more details. When you create a chart in Google Sheets, you're essentially converting data from your spreadsheet into a visual format. 4k次，点赞11次，收藏34次。博主在使用Qt的QChart显示数据曲线时遇到问题，最初一直无法画出曲线，后来发现是几个类的使用顺序不对。正确顺序是先建立QChart对象，再建立Series和Axis对象，接着用addSeries添加Series，用attachAxis绑定Axis，最后添加数据，否则曲线无法显示。 In this article you can see how to configure the series property of the Kendo UI Chart. Dec 3, 2024 · This article explains how to add series lines to charts in Excel, enhancing the visualization of data comparisons within the chart. In this Microsoft Excel tutorial you will learn how to add a data series to your chart in Microsoft Excel. That may be needed to keep updating an existing chart with additional weekly or monthly data. 1 it was working fine, but suddenly it is showing , Uncaught TypeError: chart. Chart(option); . The good news is that adding a basic legend in Excel takes only a few clicks. Learn simple methods and dynamic techniques for professional, easy-to-understand visuals. Make a regular chart from the first pivot table: select a blank cell not touching the pivot table, insert a chart, then use Select data to add a series, using the date range and counts. Jun 1, 2021 · A line that bounds a particular chart and shows the behavior as it propagates is known as a trend line. See the structure here! I managed to create the 2 different series and have them show up on the le Mar 2, 2015 · Graphical visualizations are arguably the pinnacle of how an analyst shares his/her results and possessing the ability to manipulate them is key to the field. dll 包: Microsoft. Oct 28, 2013 · I am creating a bar chart and want multiple data labels. One parameter, event, is passed to the function, containing common event information. Nov 19, 2023 · With Chart, you can automatically generate graphs based on data. Apr 21, 2023 · In Google Sheets, you can create charts with multiple series to display and compare data from different sources or categories. This task can be accomplished by right-clicking on the chart, selecting ‘Select Data,’ and then ‘Add’ to input the new series details. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. Next, options for one single series are given in the series array, or as arguments to chart. Click Switch rows / columns. 0. After After creating a chart, you might need to add an additional data series to the chart. In this post, I'll guide you through mastering data series in Excel, from organizing them efficiently to utilizing advanced techniques to enhance chart clarity. It explains what each data series in the chart represents using color coding and labels. Then add a second series, using the pivot table ranges from the second sheet, and repeat for the third. May 16, 2022 · In the main window of my PyQt application I have a QChartView. i didn't change any thing . If you’ve already created a chart in Google Sheets and spent some time adjusting the settings to get the look just right, it can be frustrating to realize you need to add more data series at a future time. Sep 4, 2025 · The containing HTML element of the chart. Double-click the chart you want to change. Two important properties of the Chart class are the Series and ChartAreas properties, both of which are collection properties. I want 7 different series on my line chart, but cannot edit the "select data" menu, it is locked to one series labeled "total" and spans each category with its own monthly timeline 7 times repeated on the x Mar 21, 2023 · The tutorial demonstrates how to make charts in Excel from multiple sheets, and how to customize and edit such graphs. add_series and . What Kind of Charts are Available? How Series are Organized As the diagram above shows, Highcharts visualizations are configured within a Chart object, which has the . The chart can be of any type like Bar Chart, Scattered Chart, Line Chart, etc. The HighchartsOptions configuration allows you to define all details of what gets displayed on the chart, how that content behaves, etc. Time series chart requires that the X axis of the chart represents time and the Y axis represents values. It's easier to use the TChart Editor to add Series at design time but you can also create and add new and differing Series types to the same Chart at runtime. If you would like an unique price scales for each individual series, particularly when dealing with data series with divergent value ranges, then take a look at the Two From v4 to v5 In this document you can find the migration guide from the previous version v4 to v5. Follow our step-by-step guide to customize your charts effectively. The chart’s legend shows series in the order they appear in the chart’s ChartControl. addCandlestickSeries is not a function. The Y axis is the value axis and points are displayed This article describes supported series types and ways to customize them. Because it fonction runs with requestData so it came after chart determine with options. Feb 3, 2025 · Discover how to add and customize series names in Excel charts to enhance clarity. Current I have to add or remove the "chart1. A series is not necessarily plotted on a chart; it can store data point values that are used to perform a calculation from which another series is created and then plotted. e. It allocates data for a lv_chart_series_t structure which contains the chosen color and an array for the data points if not using an external array, if an external array is assigned any internal points associated with the series are deallocated and the series points to the external array instead. I retrieve several datatables from my DB, which vary in size. Introduction Excel is a powerful tool for organizing and analyzing data, and one of its key features is the ability to create informative and visually appealing charts. The series object has the structure: Jun 21, 2025 · The containing HTML element of the chart. It is then associated with the data ranges in the worksheet with the help of add_series () method. line. This one of 2 is just an example. With Chart you can quickly display your data in a colorful graphic controlled by C# code. Adding Series to a Graph in Excel Starting with your Data We’ll start with the below data that shows Item A Revenue by Year. I want it to show each category as it's own line, on one single month timeline on the x axis, and amounts on the y axis.